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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

List box Expression

Hi

I want to give a list box expression: If the values of age are 30 and 50, then show age.

It works when I write this expression : =if([Age]='30', Age)

How do I also include the value 50?

It throws an error when I try to write the expression :  if([Age]={'30', '50'}, Age)

Thanks

Labels (1)
10 Replies
Anonymous
Not applicable
Author

Hi,

Use If(Match(Age, 30, 50), Age) it will work