topic Average at Script Level in QlikView

Average at Script Level

Sat, 13 Oct 2012 04:31:09 GMT

Hello,

How to calculate 5 week rolling average at the script level using RangeAvg function.

Attaching excel file for your reference.

swuehl — Sat, 13 Oct 2012 09:58:14 GMT

LOAD [Fiscal Week Ending],

Amount,

[5 Week Rolling Avg],

rangeavg(

Amount,

peek(Amount,-1),

Peek(Amount,-2),

peek(Amount,-3),

peek(Amount,-4)

) as myRollingAvg

FROM

(biff, embedded labels, table is Sheet1$);

Hope this helps,

Stefan

Sat, 13 Oct 2012 17:28:18 GMT

Dear Stefan,

This is great. Helped me a lot.

Thanks a lot for your reply.

Nassar