Drop Down Menu In Qlik Sense

[dustonmoore]

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?

[agigliotti]

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

[Chanty4u]

you want drilldown?

if yes

you can create master dimension.

[MK9885]

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]

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

[MK9885]

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]

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...

[MK9885]

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?

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.