Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Go to Solution.
Oops. brainfart Try this instead:
rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,4)) -1
Try this: rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,56)) -1
Thanks for your reply,
I am getting some different percentages, not exactly as show in excel.
Could you please advice on this