if statement - multiple if's for calculated field in tableau -


Please forgive the very newbie question but I'm very new to makeup what I want to do, a message on it I will do something like:

  message = '' if filter 1 == 1: message + = 'activate filter 1, if the filter flags are activated, then in the psuedo code, I will do something like: 'If filter2 == 1: message + =' filter2 is active 'return message   

is the problem, I'm also not sure if the statements How to do several times - I get a syntax error. Any help would be greatly appreciated.

Here's an example of how I accomplished something like this:

 < code> If [ZAVUFA1_FED_COLL_CHOICE_1] = 'xxxxx' is 1 elseif [ZAVUFA1_FED_COLL_CHOICE_2] = 'xxxxx' then 2 elseif [ZAVUFA1_FED_COLL_CHOICE_3] = 'xxxxx' then 3 elseif [ZAVUFA1_FED_COLL_CHOICE_4] = 'xxxxx' then 4 elseif [ZAVUFA1_FED_COLL_CHOICE_5] = 'xxxxxx' then 5 elseif [ZAVUFA1_FED_COLL_CHOICE_6] = 'xxxxx' then 6 elseif [ZAVUFA1_FED_COLL_CHOICE_7] = 'xxxxxx' is 7 elseif [ZAVUFA1_FED_COLL_CHOICE_8] = 'xxxxxx' and 8 elseif [ZAVUFA1_FED_COLL_CHOICE_9] = 'xxxxx' then 9 elseif [ZAVUFA1_FED_COLL_CHOICE_10] = 'Xxxxxx' THEN 10 ELSEIF ISNULL ([ZAVUFA1_FED_COLL_CHOICE_1]) THEN 99 END   

As much as I love stackoverflow, Takhtau also loves them There is a good user forum on the site.

Comments