topic Re: Problem with rolling week average in QlikView https://community.qlik.com/t5/QlikView/Problem-with-rolling-week-average/m-p/741195#M264737 <HTML><HEAD></HEAD><BODY><P>Since you didn't post a qlikview document that shows what you're actually doing and the data you're using I can only suggest you try the approach described in this document: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Fri, 14 Nov 2014 09:31:26 GMT Gysbert_Wassenaar 2014-11-14T09:31:26Z Problem with rolling week average https://community.qlik.com/t5/QlikView/Problem-with-rolling-week-average/m-p/741194#M264736 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>The file attached is an extract form my QV solution. The problem I am having is in column C (4 weeks rolling average) which returns a wrong value regardless of how much I change up the expression. I found this formula from these discussion threads</P><P></P><P><A href="https://community.qlik.com/thread/54383">Moving Averages in Charts</A></P><P><A href="http://www.qlikcommunity.com/thread/23055" title="http://www.qlikcommunity.com/thread/23055">moving average in qlikview | Qlik Community</A></P><P></P><P>Kindly someone help me out on what exactly is going wrong in my calculations?</P><P></P><P>Cheers</P></BODY></HTML> Thu, 13 Nov 2014 16:22:26 GMT https://community.qlik.com/t5/QlikView/Problem-with-rolling-week-average/m-p/741194#M264736 2014-11-13T16:22:26Z Re: Problem with rolling week average https://community.qlik.com/t5/QlikView/Problem-with-rolling-week-average/m-p/741195#M264737 <HTML><HEAD></HEAD><BODY><P>Since you didn't post a qlikview document that shows what you're actually doing and the data you're using I can only suggest you try the approach described in this document: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Fri, 14 Nov 2014 09:31:26 GMT https://community.qlik.com/t5/QlikView/Problem-with-rolling-week-average/m-p/741195#M264737 Gysbert_Wassenaar 2014-11-14T09:31:26Z