Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Rolling Average

Morning all.

I have been tasked from my new client to do a 12 month rolling average in an existing Dashboard. The data is at a granular level and needs to stay at this level. I have tried the Accumulate 12 steps back but this didn't work as I do not measure by day I measure by site. Any help is much appreciated.

James

5 Replies

Re: Rolling Average

Have you tried using RangeSum(Above/Below()) functions?

Not applicable

Re: Rolling Average

tried that.

Re: Rolling Average

Not applicable

Re: Rolling Average

Hi Marcus looks interesting I will give it a try on my test data and see.

Employee
Employee

Re: Rolling Average

You can also use an As-Of table. See The As-Of Table.

HIC

Community Browser