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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use set in expression

Hi,

I have one scenario, I have a field named 'Category', it has three values:A,B,C

I have one object, say label, I want to show or hide it based on the Category.

If Category is A or B , it shows.

I know we can use a expression to achieve. But how to use like a set, for example: Category='A,B' ?

2 Replies
Anonymous
Not applicable
Author

You could do:

If(Category='A' or Category='B', 1, 0)

Anonymous
Not applicable
Author

if(Findoneof(Category,'AB')<>0,1,0) should work too