Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Giving a range of values as the expression

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?

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

Use instead

='<=' & $(Load_Yr)

Hope that helps.

Miguel

View solution in original post

2 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Can you attach sample file to check.

Miguel_Angel_Baeyens

Hi,

Use instead

='<=' & $(Load_Yr)

Hope that helps.

Miguel