5 Replies Latest reply: Nov 4, 2016 1:43 AM by Soumya Narayanan RSS

    Measure based on previous month

    Soumya Narayanan

      Hi,

      I need to calculate the Count(ID) for each month in the year based on previous month's Count(ID) value

       

      MonthEnd ValueBegin Value
      Jan-16100-
      Feb-16200100
      Mar-16300200
      Apr-16400300

       

       

      In the above table:

      End Value = Count(ID)

      Begin Value = End Value of previous month

      I need to create a measure that calculates the Begin Value.

       

      How do I achieve this in Qlik Sense?