1 Reply Latest reply: May 1, 2018 5:11 AM by Sunny Talwar RSS

    Cumulative Calculations per year

    Robbert Sam-Sin

      Hi Guys,


      I want to make the following calculation in Qlik. Do you recommend to do this in the script or front end?

      (Value_T + Value_T-1)/2/12*multiplier_T


      This calculation has to be done when ID and client in Period T and T-1 are equal. And if there is no comparable combination in the previous period the Value has to be set at 0.


      Question.PNG

       

      Next,

      I want that the calculation restarts every year. Therefor I am using the following formula:

      Sum(Aggr(

      Rangesum(Above((Sum(Value) + Above(Sum(Value)))/2/12*Multiplier,0,rowno())),

      Date, (Date Month, (Numeric, Ascending))))

       

      Thanks in advance