topic Weekly rolling averages in QlikView https://community.qlik.com/t5/QlikView/Weekly-rolling-averages/m-p/388258#M490537 <HTML><HEAD></HEAD><BODY><P>Hello Gurus,</P><P></P><P>Would apprecaite your help on calculating weekly rolling average in QV , exactly&nbsp; as shown in the excel attachment.</P><P></P><P>Tried with the rangeavg function, but no success.</P><P></P><P>Need your assitance.</P><P></P><P></P><P>Nassar</P></BODY></HTML> Sat, 06 Oct 2012 06:25:16 GMT 2012-10-06T06:25:16Z Weekly rolling averages https://community.qlik.com/t5/QlikView/Weekly-rolling-averages/m-p/388258#M490537 <HTML><HEAD></HEAD><BODY><P>Hello Gurus,</P><P></P><P>Would apprecaite your help on calculating weekly rolling average in QV , exactly&nbsp; as shown in the excel attachment.</P><P></P><P>Tried with the rangeavg function, but no success.</P><P></P><P>Need your assitance.</P><P></P><P></P><P>Nassar</P></BODY></HTML> Sat, 06 Oct 2012 06:25:16 GMT https://community.qlik.com/t5/QlikView/Weekly-rolling-averages/m-p/388258#M490537 2012-10-06T06:25:16Z Re: Weekly rolling averages https://community.qlik.com/t5/QlikView/Weekly-rolling-averages/m-p/388259#M490538 <HTML><HEAD></HEAD><BODY><P>Try this: rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,56)) -1</P></BODY></HTML> Sat, 06 Oct 2012 07:06:23 GMT https://community.qlik.com/t5/QlikView/Weekly-rolling-averages/m-p/388259#M490538 Gysbert_Wassenaar 2012-10-06T07:06:23Z Re: Weekly rolling averages https://community.qlik.com/t5/QlikView/Weekly-rolling-averages/m-p/388260#M490539 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks for your reply,</P><P></P><P>I am getting some different percentages, not exactly as show in excel.</P><P></P><P> Could you please advice on this</P></BODY></HTML> Sat, 06 Oct 2012 13:24:47 GMT https://community.qlik.com/t5/QlikView/Weekly-rolling-averages/m-p/388260#M490539 2012-10-06T13:24:47Z Re: Weekly rolling averages https://community.qlik.com/t5/QlikView/Weekly-rolling-averages/m-p/388261#M490540 <HTML><HEAD></HEAD><BODY><P>Oops. brainfart <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /> Try this instead: </P><P>rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,4)) -1</P></BODY></HTML> Sat, 06 Oct 2012 14:03:57 GMT https://community.qlik.com/t5/QlikView/Weekly-rolling-averages/m-p/388261#M490540 Gysbert_Wassenaar 2012-10-06T14:03:57Z