topic Re: Multibox - Display only selected values in QlikView

Multibox - Display only selected values

stuwannop — Tue, 25 Jun 2013 11:05:32 GMT

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

Re: Multibox - Display only selected values

Gysbert_Wassenaar — Tue, 25 Jun 2013 11:07:09 GMT

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

Re: Multibox - Display only selected values

stuwannop — Thu, 27 Jun 2013 09:40:11 GMT

Thanks works great.

Stu