Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dustonmoore
New Contributor II

Drop Down Menu In Qlik Sense

Hey guys,

I am transitioning from Qlik View to Qlik Sense. I would like to have a drop down menu for year and month selection in Qlik Sense. Is there an easy way to do this?

7 Replies
agigliotti
Honored Contributor II

Re: Drop Down Menu In Qlik Sense

what do you means with drop down menu ? a ListBox  object ?

Chanty4u
Esteemed Contributor III

Re: Drop Down Menu In Qlik Sense

you want drilldown?

if yes

you can create master dimension. maste.PNG

Khan_Mohammed
Honored Contributor II

Re: Drop Down Menu In Qlik Sense

By default objects you cannot have 2 dimensions in one filter.

As Chanty mentioned above, make Year and Month as a drill down dimension, use that dimension in your filter.

It can be drop down based on the size of your filter, which is usually small in size.

dustonmoore
New Contributor II

Re: Drop Down Menu In Qlik Sense

I want a box that says select year, when selected, each available year drops down for selection.

Khan_Mohammed
Honored Contributor II

Re: Drop Down Menu In Qlik Sense

Untitled.png

Not sure what you need but maybe....

Create a drill down dimension with Year and Month.

Create a variable for Year- 'Select Year'& Year

Create a variable for Month- 'Select Month'& Month

In your filter, use drill down dimension and for label use

=if(GetSelectedCount(Year)=0,$(Y),

if(GetSelectedCount(Year)>0,$(M)))

If nothing is selected the filter would say 'Select Year' once Year is selected it would say Select Month. A dynamic way to change the label.

dustonmoore
New Contributor II

Re: Drop Down Menu In Qlik Sense

No, this still isn't it. Here is a perfect example of what I want - Plant Operations

I would like the Select Year Drop Down on that example...

Khan_Mohammed
Honored Contributor II

Re: Drop Down Menu In Qlik Sense

That is a Mashup example.

HTML Inspect Code is....

If you know about HTML/JS/CSS then download a filter extension with open source code, edit it accordingly for drop down?

Untitled.png

BTW, Qlik by default can do that as well, you need 2 separate filters, only thing you'll miss is a drop down arrow. Rest all is same.

Field UI is a great extension to start... it has drop down feature.

Community Browser