Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated Dimension with Multiple Values

I'm trying to select multiple values for a dimension and it only recognizes the first value.

=[Sales Comp] = 'WES' or 'DST' or 'DOT'

I've tried different syntax, but nothing seems to work.  Any ideas?  Thanks.

1 Solution

Accepted Solutions
Not applicable
Author

try with

=if([Sales Comp]='WES' or 'DST' OR 'DOT', [Sales Comp])

View solution in original post

1 Reply
Not applicable
Author

try with

=if([Sales Comp]='WES' or 'DST' OR 'DOT', [Sales Comp])