topic Re: MOVING AVERAGE ??? in QlikView

MOVING AVERAGE ???

Fri, 20 Mar 2015 10:02:01 GMT

Dear all,

I have calculated the 06 month moving average by using following expression starting from Jan'2013.

RANGEAVG(ABOVE(RANGESUM(PREMIUM),0,6))

But the results are not in order since Jan'2014 , may be due to year change. Please any one can help me urgently.

Results of the same table is as follows.

Priyantha.

Gysbert_Wassenaar — Fri, 20 Mar 2015 10:45:53 GMT

Yes, when you want to cross dimension borders you need to add the TOTAL keyword

RANGEAVG(ABOVE(TOTAL RANGESUM(PREMIUM),0,6))

Fri, 20 Mar 2015 11:16:25 GMT

Dear Gysbert,

by adding total keyword whole dimension borders are crossing. Just i want to cross only the Year border

Priyantha.

Gysbert_Wassenaar — Fri, 20 Mar 2015 11:24:57 GMT

That's not possible. You'll have to use another approach. See this document: Calculating rolling n-period totals, averages or other aggregations

Fri, 20 Mar 2015 11:30:26 GMT

Thanks........Gybert,