2 Replies Latest reply: Feb 9, 2012 7:49 AM by Miguel Angel Baeyens de Arce RSS

    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?