Adding ListBox in Qlik Sense

[qlikcheepirishe]

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.

[OmarBenSalem]

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

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

[qlikcheepirishe]

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 :

But instead the name of the new created master dimension

[qlikcheepirishe]

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,