Giving a range of values as the expression

[#1]

Hi all,

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?

[jagannalla]

Can you attach sample file to check.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Use instead

='<=' & $(Load_Yr)

Hope that helps.

Miguel