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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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

10 Replies
Anonymous
Not applicable
Author

Hi,

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