Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rolling Average Help!

Greetings,

This is my first post/question here... I'm a 'newbie' to QlikView.

I was wondering if anyone could help me with a set analysis calculation for rolling averages...

I'm looking to calculate the 4 week rolling average.

Also, if it's possible, I'm looking to also calculate the previous month's 4 week rolling average.

See the following table:

WeekDate Ending Prod

48

12/4/201088,491
4912/11/2010122,631
5012/18/2010126,258
5112/25/201087,306

Any input is greatly appreciated... If I haven't provided enough info let me know and I can provide more.

Thanks

1 Reply
MK_QSL
MVP
MVP

Create a Straight Table

Dimension

Week

Expression

SUM(Sales)

RangeAvg(Above(SUM(Sales),0,4))