Centered Moving Average in Qlikview?

Tue, 03 Mar 2015 09:55:24 GMT

Hi,

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

rangeavg(above(Sales,0,3))

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?

Best regards,

Claus

Re: Centered Moving Average in Qlikview?

simenkg — Tue, 03 Mar 2015 09:59:40 GMT

How about:

rangeavg(above(Sales,0,2),below(Sales, 1, 1))

Tue, 03 Mar 2015 10:06:25 GMT

Thank you so much Simen - that works perfectly

You're my hero!