topic Re: Have a problem in zooming. in QlikView https://community.qlik.com/t5/QlikView/Have-a-problem-in-zooming/m-p/503122#M552182 <HTML><HEAD></HEAD><BODY><P>The above function you use cannot use values that are not shown in the chart. If you make a selection then then first weeks of the selection will show wrong results. There are solutions for that. See 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; text-decoration: underline;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Tue, 22 Oct 2013 10:49:32 GMT Gysbert_Wassenaar 2013-10-22T10:49:32Z Have a problem in zooming. https://community.qlik.com/t5/QlikView/Have-a-problem-in-zooming/m-p/503121#M552181 <HTML><HEAD></HEAD><BODY><P>Friends,</P><P></P><P>I have 4-week moving average trend line calculation using RangeAvg(Above(Sum(value),0,4)). Which will show correct values that we expected. While zooming the particular portion from the&nbsp; chart, then the trend-line showing wrong result. How to solve the problem. Or any other effective way is there to calculate the 4-week moving average calculation.</P><P></P><P>Thank you,&nbsp; </P></BODY></HTML> Tue, 22 Oct 2013 10:43:59 GMT https://community.qlik.com/t5/QlikView/Have-a-problem-in-zooming/m-p/503121#M552181 2013-10-22T10:43:59Z Re: Have a problem in zooming. https://community.qlik.com/t5/QlikView/Have-a-problem-in-zooming/m-p/503122#M552182 <HTML><HEAD></HEAD><BODY><P>The above function you use cannot use values that are not shown in the chart. If you make a selection then then first weeks of the selection will show wrong results. There are solutions for that. See 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; text-decoration: underline;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Tue, 22 Oct 2013 10:49:32 GMT https://community.qlik.com/t5/QlikView/Have-a-problem-in-zooming/m-p/503122#M552182 Gysbert_Wassenaar 2013-10-22T10:49:32Z