3 month rolling average before and after

Thu, 04 Aug 2011 10:35:13 GMT

Hi All

IN a pivot table I have been trying to calculate a time series showing a 3 month rolling average that includes the month before and month after the current month eg for April i want the average to be for data in March, April and May. I could not find the answer on the community so thought i woudl put it up if others are having the same problem.

Solution:

=rangeavg(after($(varActivity),0,2), before($(varActivity),1,1) )

Note i think this will only work in pivot tables

thanks

dan

Re: 3 month rolling average before and after

SunilChauhan — Thu, 04 Aug 2011 12:19:11 GMT

please see the attached

replace fields

you will get the desired result

topic 3 month rolling average before and after in QlikView

3 month rolling average before and after

Re: 3 month rolling average before and after