topic Rolling Month Average in QlikView

Rolling Month Average

abhaysingh — Tue, 05 May 2015 04:15:07 GMT

Hi All,

i want one analysis in which for every current month value it should calculate back three month average.i.e

For Apr= (Jan+Feb+Mar)/3

For Mar = (jan2015+feb2015+dec2014)/3

for Feb = (jan2015+dec2014+nov2014)/3

please help me in that..

thanks

tresB — Tue, 05 May 2015 04:52:45 GMT

It depends on several things to approach. Where do you want this to be calculated, a textbox or chart? If chart, what would the there in the dimension? For generic, read :Calculating rolling n-period totals, averages or other aggregations

For specific help, try to create a sample qvw and share.

abhaysingh — Tue, 05 May 2015 04:54:32 GMT

hi tressco,

i have to show it as a trend for month dimension in line chart.

thanks

tresB — Tue, 05 May 2015 05:05:14 GMT

Read the post by gwassenaar I suggested above. It explains the similar topic very nicely. Otherwise, a sample qvw could help me help you.

jagan — Tue, 05 May 2015 06:48:58 GMT

Hi,

As tresesco suggested if you attach a sample file with your expected output it would be easier to solve.

Regards,

Jagan.