I have a parameter called Group Select. the choices are All and Special. CASE [Group Select] When 'Special' Then [Subset]='A' OR [Subset]=B' When 'All' ........

Question

How do I add the control such that When 'ALL' is selected I get ALL subsets? like [Subset] = "*" or [Subset] = "All" It seems I only can have " Special or Not Special"

Any Ideas? Thank you

Budi Lubis · Accepted Answer

Hi @CHRISTOPHER DAVIS​ - Modify the calculate field as follow.  Drop to  filter  > select  true .   [Group Select]="Special" AND [Subset] IN("A","B") OR [Group Select]="All"

Tableau Community Forums Member (Inactive) · Answer

Thank you Budi! I will try this. I also found adding ELSE Null = TRUE seems to work as the "alternate case" Does it make sense why it should? I will try your solutions. Looks more elegant!   [UPDATE]  tried Budi solution.  Worked PERFECTLY!   thank you!

I have a parameter called Group Select. the choices are All and Special. CASE [Group Select] When 'Special' Then [Subset]='A' OR [Subset]=B' When 'All' ........

Tableau Desktop & Web Authoring

Related Learning

More Help