Discussion board where members can get started with QlikView.
I would like to know how to create a centered moving average in qlikview.
So far, I have only been able to create a moving average looking a certain number of weeks into the past or future. This was using the
Which looks 3 weeks into the past.
If i put a negative number in the offset, it will become a below( formula instead.
So what it is doing now is this:
What I want it to do is this:
Can anyone tell me how to do this?
rangeavg(above(Sales,0,2),below(Sales, 1, 1))
View solution in original post
Thank you so much Simen - that works perfectly
You're my hero!