Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
qlikcheepirishe
Contributor

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
Esteemed Contributor

Re: Adding ListBox in Qlik Sense

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

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

qlikcheepirishe
Contributor

Re: Adding ListBox in Qlik Sense

thanks it is helpful omarbensalem

OmarBenSalem
Esteemed Contributor

Re: Adding ListBox in Qlik Sense

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
Contributor

Re: Adding ListBox in Qlik Sense

I am using qliksense desktop 3.1 SR3.

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

OmarBenSalem
Esteemed Contributor

Re: Adding ListBox in Qlik Sense

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,