Rolling Average Help!

[#1]

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:

Week	Date Ending	Prod
48	12/4/2010	88,491
49	12/11/2010	122,631
50	12/18/2010	126,258
51	12/25/2010	87,306

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

Thanks

[MK_QSL]

Create a Straight Table

Dimension

Week

Expression

SUM(Sales)

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