topic Re: Calculate running average in table in QlikView

Calculate running average in table

villegasi03 — Fri, 24 Aug 2012 19:04:26 GMT

QV Community,

I was hoping that someone could provide me some assitance in calculating a running average in a pivot table or straight table when using a date as a dimension. I am assuming that I have to use set analysis but I am having some dificulty with finding the correct expression.

Thank you,

Date	Count	? HELP ME ?
8/1/2012	190	190
8/2/2012	179	185
8/3/2012	187	185
8/6/2012	294	213
8/7/2012	263	223
8/8/2012	196	218
8/9/2012	176	212
8/10/2012	159	206
8/13/2012	318	218
8/14/2012	228	219
8/15/2012	187	216
8/16/2012	189	214
8/17/2012	121	207
8/20/2012	213	207
8/21/2012	103	200
8/22/2012	63	192
8/23/2012	52	183
8/24/2012	3	173

Re: Calculate running average in table

Fri, 24 Aug 2012 19:27:31 GMT

Rangeavg(above(Count(count),0,12)) This expression will give a rolling 12 month average including the current row, and going back 11 rows. If you want everything before each row averaged then Rangeavg(above(Count(count),0,noofrows())) should work

Re: Calculate running average in table

villegasi03 — Mon, 27 Aug 2012 13:06:44 GMT

Marcsliving,

Than you very much for you assistance. This worked great!