5 Replies Latest reply: Oct 9, 2013 7:31 AM by Andrew Epps RSS

    Lag function

      I'm new to Qlikview and have a specific problem that highlights a broader issue that I'm not sure about yet.

       

      The problem is whether it is possible to use lag values in a straight table i.e.  To create the following:

       

      MonthSum(Value)Lag SUM(Value)
      Januarya-
      Februaryba
      Marchcb
      Aprildc

       

      My ultimate aim is to be able to create a column where I compare the Value with the lag value, but I want to get there in stages.

       

      One solution would be to create another column as I load the data. But is that the best way of doing it? If the dataset were large it would slow down loading. In this situation the data is small, but I often work with big datasets.

       

      Any help would be much appreciated.