Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a Straight Table
Dimension
Week
Expression
SUM(Sales)
RangeAvg(Above(SUM(Sales),0,4))