I am new to Qlikview. I have the following requirement.
I have a list box with the release months - Jan 2017, Feb 2017, March 2017, ..... Dec 2017, Jan 2018, Feb 2018... April 2018.
I have expanded this list box to show values horizontally in my dashboard.
To avoid all values to show in the top(the values will keep increasing every year), i need to do the following:
Need to add Year field. Based on user selection of the year, i should show only those in the list box.
Eg: if they select 2017, then Release months should show only from Jan 2017 to Dec 2017 with Jan defualted. When they click 2018, then Jan 2018 - April 2018 with Current Month defualted should show up. Similarly for any other years.
