Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cumulative Calculations per year

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

1 Reply
sunny_talwar

One option is to use The As-Of Table