topic Re: Rolling 12 Month Sum/Average in QlikView

Rolling 12 Month Sum/Average

Thu, 17 Dec 2015 11:32:49 GMT

Hi All,

I have a line chart, dimension of month/year with, expression is a sum. The dataset contains 24 months of data, but I'm only displaying months 13 to 24 on the chart.

I'm trying to add an additional line on the chart that shows a 'rolling 12 month' sum. So the point at month 24 should show the sum of months 13 to 24, the point at month 23 should show the sum of months 12 to 23 etc. I'd like to do the same for an average calculation.

Does any one have any suggestions?

Thanks in advance

Tom

Re: Rolling 12 Month Sum/Average

Gysbert_Wassenaar — Sat, 19 Dec 2015 07:59:02 GMT

See this document: Calculating rolling n-period totals, averages or other aggregations

And these blog posts:

Accumulations‌

The As-Of Table

Re: Rolling 12 Month Sum/Average

ecolomer — Sat, 19 Dec 2015 08:30:01 GMT

See this: