First welcome to the forum
please see the link Getting Started in the Forums - it will present how to get the most out of you posts
since you did not provide a twbx workbook I can't be more specific but in concept you can just create a conditional If .. then ..elseif statement
and place you clauses sequential in order of your priorities
the statement will take the first True value and execute the then - and then will process the next record
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
There a a few easy ways to do this:
A) Create a group with the gui:
B) Create a calculated field:
when "V1" then "Cat A"
when "V2" then "Cat A"
when "V3" then "Cat B"
when "V4" then "Cat C"
Both are included in the attached workbook.
Book1.twbx 49.6 KB
Thanks for your response
but I have a fairly exhaustive list of Values so writing a case statement for each value is not practical....
do we have a SQL IN clause or excel Vlookup() equivalent in Tableau...
I will try to upload the workbook for clarity...
also if else or case is not feasible as I have to read it from a list as the values run in 1000s...
Thanks for your response Thomas!!!....
However, my problem is in the sheer number of records I am dealing in....
I have around 500 values that are linked to series Axxx.... (most are overlapping with also records against series ISxxx and other categories as I mentioned in original mail...)
Also I cannot group the values as they are difficult to identify.... Rather it is the Category series A*** which has some pattern (reason why I created a set on Category tedious but still doable.. not sure if its optimal)... Having identified the category I need to extend the identified category set and somehow for all corresponding values across all records need to be labelled as belonging to Cat A.