Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikcheepirishe
Creator
Creator

Adding ListBox in Qlik Sense

I have Data in which Year field is from 2000 to 2017.

I want to take the Year Field (i.e. listbox) from Year 2011 to 2015 in list box.

what is the script behind to add just Year 2011,2012,2013,2014 & 2015.

5 Replies
OmarBenSalem

Create a new listBox object, and as a dimension enter:

=if(Year>=2011 and Year<=2015,Year,Null())

qlikcheepirishe
Creator
Creator
Author

thanks it is helpful omarbensalem

OmarBenSalem

I'd propose you build it as a master dimension if you're using qlik sense 3.2; that way, when you make a selection in this new field, in the selection bar, you won't get the expression shown :

Capture.PNG

But instead the name of the new created master dimension

qlikcheepirishe
Creator
Creator
Author

I am using qliksense desktop 3.1 SR3.

so is there any other way to remove the expression after selection the year field

OmarBenSalem

No, the only way is to upgrade to the latest version(3.2) as I already told you.

If your question have been answered, please close the thread by marking the correct answer as correct.

Omar,