9 Replies Latest reply: Dec 29, 2009 12:03 PM by Franck Robert RSS

    Comparing years without using set analysis

    Franck Robert


      I would like to create a chart displaying an indicator / year. A new column should contain the value for the previous year. As soon as I wouldn't like to force a selection, it should work without using set analysis. It should also work if the sort on year change (should therfore not use below and above).
      Does a formula like that exists in Qlikview :
      Indicator N-1 = value of indicator for the dimension minus 1

      Year Indicator Indicator N-1

      2007 90 -

      2008 100 90

      2009 143 100