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: 
stuwannop
Partner - Creator III
Partner - Creator III

Multibox - Display only selected values

Hi Everyone

I have a multibox set up which allows the user to select a year value. The year in the raw data goes up to 2099 (this can't be helped) but I only want the user to be able to see 2013 & 2014. Filtering the core data is not an option, I need to add an expression  in the multibox can  someone help?

Thanks in advance.

Stu

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try an expression like =if(year=2013 or year=2014,year) instead of using the field name


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try an expression like =if(year=2013 or year=2014,year) instead of using the field name


talk is cheap, supply exceeds demand
stuwannop
Partner - Creator III
Partner - Creator III
Author

Thanks works great.

Stu