Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Weekly rolling averages

Hello Gurus,

Would apprecaite your help on calculating weekly rolling average in QV , exactly  as shown in the excel attachment.

Tried with the rangeavg function, but no success.

Need your assitance.

Nassar

1 Solution

Accepted Solutions

Re: Weekly rolling averages

Oops. brainfart Try this instead:

rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,4)) -1


talk is cheap, supply exceeds demand
3 Replies

Re: Weekly rolling averages

Try this: rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,56)) -1


talk is cheap, supply exceeds demand
Not applicable

Re: Weekly rolling averages

Hi,

Thanks for your reply,

I am getting some different percentages, not exactly as show in excel.

Could you please advice on this

Re: Weekly rolling averages

Oops. brainfart Try this instead:

rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,4)) -1


talk is cheap, supply exceeds demand
Community Browser