topic Accumulated Sum in QlikView

Accumulated Sum

Anonymous — Thu, 26 Jun 2014 11:13:07 GMT

Hi All,

Please can you help me resolving the issue that i have in that expression :

I am trying to get the accumulated sum of my last 3 months.

For that i created a date dimension based on the year and the number of the month that i get from my dataset and a Date-2 dimension, to give me the Date-2months.

Please find attached my application any help is appreciate.

Thanks a lot

Re: Accumulated Sum

Gysbert_Wassenaar — Thu, 26 Jun 2014 11:24:30 GMT

Set analysis calculates one set per chart, not a set per dimension value. If you use month as a dimension and you want a 3-month accumulated sum then using set analysis is very tricky. I find it easiest to create a new table that links each month value with the last 3 months. See this document for more information: Calculating rolling n-period totals, averages or other aggregations