This content has been marked as final. Show 2 replies
I am using Qlikview version9. My dashboard contains data for the years 2010,2011 and 2012.
When I select the value 2012, I want all values <=2012 to be selected, ie 2010, 2011, 2012.
And when I select the value 2011, the values <=2011 should be selected, ie 2010,2011.
Similarly when i select the value 2010, 2010 will be selected.
I am using 3 buttons for the 3 years to achieve this. In the Actions tab, I give the value of the field YEAR as <=2012, <=2011 and <=2010 respectively. And it is working fine.
Now I want to change the hard-coded values to dynamic values. I have defined a variable Load_Yr for 2012, and Load_Yr-1 gives 2011, Load_Yr-2 gives 2010. I need to change the value of the field in Actions tab from <=2012 to <=Load_Yr and so on. It works fine if I give =Load_Yr but its not working when I give <=Load_Yr.
Can you provide a solution?