Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
villegasi03
Creator
Creator

Calculate running average in table

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,

DateCount ? HELP ME ?
8/1/2012190 190
8/2/2012179 185
8/3/2012187 185
8/6/2012294 213
8/7/2012263 223
8/8/2012196 218
8/9/2012176 212
8/10/2012159 206
8/13/2012318 218
8/14/2012228 219
8/15/2012187 216
8/16/2012189 214
8/17/2012121 207
8/20/2012213 207
8/21/2012103 200
8/22/201263 192
8/23/201252 183
8/24/20123 173
1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

2 Replies
Not applicable

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

villegasi03
Creator
Creator
Author

Marcsliving,

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