Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
what do you means with drop down menu ? a ListBox object ?
you want drilldown?
if yes
you can create master dimension.
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.
I want a box that says select year, when selected, each available year drops down for selection.
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.
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...
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.