topic Re: Rolling N Months Calculation in QlikView

Rolling N Months Calculation

Mon, 12 Aug 2013 11:43:38 GMT

Hello,

I have a table like this:

	Jan	Feb	Mar	Apr	May
Amount	120	232	302	322	382

When I select Apr, the Pivot Table only shows:

	Apr
Total = Sum(Amount)	322

How could I make Total to be sum of Feb's, Mar's and Apr's amount, i.e. rolling 3 months, and giving out 856, i.e. 232 + 302 + 322?

Please help and advise. Thank you.

Re: Rolling N Months Calculation

er_mohit — Mon, 12 Aug 2013 11:57:29 GMT

See the attached file

Re: Rolling N Months Calculation

Tue, 13 Aug 2013 07:57:10 GMT

Hello,

Thanks for your help. However, is there a way I could hide the previous months? For example, if I select Apr and May, Feb and Mar would be hidden, however, Apr and May could still show the accumulated total. Is that possible? Please help and advise. Thank you.

Re: Rolling N Months Calculation

Gysbert_Wassenaar — Tue, 13 Aug 2013 11:49:04 GMT

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