topic Rolling Average and Sum in QlikView https://community.qlik.com/t5/QlikView/Rolling-Average-and-Sum/m-p/134929#M20207 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi <A href="https://community.qlik.com/qlik-users/4003">hic</A>‌,<SPAN style="font-size: 13.3333px;">‌</SPAN></P><P style="font-size: 13.3333px;">I am trying to understand the difference of accumulations and which one are the correct&nbsp; formulas for its calculation for rolling averages and sums.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Follow attached the excel file with formulas. Can you help?</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks!</P></BODY></HTML> Fri, 27 Jul 2018 12:38:46 GMT yurgelmartina 2018-07-27T12:38:46Z Rolling Average and Sum https://community.qlik.com/t5/QlikView/Rolling-Average-and-Sum/m-p/134929#M20207 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi <A href="https://community.qlik.com/qlik-users/4003">hic</A>‌,<SPAN style="font-size: 13.3333px;">‌</SPAN></P><P style="font-size: 13.3333px;">I am trying to understand the difference of accumulations and which one are the correct&nbsp; formulas for its calculation for rolling averages and sums.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Follow attached the excel file with formulas. Can you help?</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks!</P></BODY></HTML> Fri, 27 Jul 2018 12:38:46 GMT https://community.qlik.com/t5/QlikView/Rolling-Average-and-Sum/m-p/134929#M20207 yurgelmartina 2018-07-27T12:38:46Z Re: Rolling Average and Sum https://community.qlik.com/t5/QlikView/Rolling-Average-and-Sum/m-p/134930#M20208 <HTML><HEAD></HEAD><BODY><P>I think so from the attachment, Column G(RangeSum) &amp; Column J(RangeAvg) are created with proper expressions.</P></BODY></HTML> Fri, 27 Jul 2018 16:42:37 GMT https://community.qlik.com/t5/QlikView/Rolling-Average-and-Sum/m-p/134930#M20208 BalaBhaskar_Qlik 2018-07-27T16:42:37Z