Discussion board where members can get started with Qlik Sense.
Hi, my data set is structured by a master calendar with monthname() as the resulting value (Jan 2017, Feb 2017, etc). When using the filter pane I get a long list of months/years, but I would like to build a drill-down feature where the user can select the 1. year, and then the 2. month. Is this possible to do? Thank you for your help!
Solved! Go to Solution.
Yes, It's perfectmy possible.
1) You create an hiearchical dimension as a master dimension composed of year and month:
2) You use a bar chart for example, and as a dimension, you choose the newly created one (the hierarchical):
To go the months, select a year and confirm, its months will appears as dimensions:
To go back to Year dimension, just click on the year (under the x-axis)
Hope this helps
thank you Omar. My data isnt broken up by two columns (month, and year) the two dimensions required for your suggestion. Right now it's just 1 column/ dimension with month-year for example (Jan 2017). What are your thoughts on what to do next?
What I would do Monica, is creating those 2 new fields in the sript:
suppose your table is as follow:
subfield(CalMonth,' ',1) as Month,
subfield(CalMonth,' ',2) as Year;
And the use these 2 new fields !
Have Nice days Monic !