topic Re: Do not plot first few values in accumulation in QlikView https://community.qlik.com/t5/QlikView/Do-not-plot-first-few-values-in-accumulation/m-p/708289#M1081391 <HTML><HEAD></HEAD><BODY><P>You can't with using the accumulation option of the chart. You could try setting the background color to 100% transparant, but you'll still see the dates on the x-axis. Or you can use an AsOf table as explained 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, 04 Jul 2014 08:37:52 GMT Gysbert_Wassenaar 2014-07-04T08:37:52Z Do not plot first few values in accumulation https://community.qlik.com/t5/QlikView/Do-not-plot-first-few-values-in-accumulation/m-p/708288#M1081390 <HTML><HEAD></HEAD><BODY><P>I am accumulating one of my expressions 4 steps back and then dividing it by 4 to get the 4 weekly rolling average. However the first 3 weeks of the chart are obviously misleading because there isn't enough data. How can I ensure those first 3 values are not plotted?</P><P></P><P><IMG alt="rolling 4 weeks.png" class="jive-image" src="/legacyfs/online/61690_rolling 4 weeks.png" style="width: 620px; height: 374px;" /></P></BODY></HTML> Thu, 03 Jul 2014 14:28:51 GMT https://community.qlik.com/t5/QlikView/Do-not-plot-first-few-values-in-accumulation/m-p/708288#M1081390 2014-07-03T14:28:51Z Re: Do not plot first few values in accumulation https://community.qlik.com/t5/QlikView/Do-not-plot-first-few-values-in-accumulation/m-p/708289#M1081391 <HTML><HEAD></HEAD><BODY><P>You can't with using the accumulation option of the chart. You could try setting the background color to 100% transparant, but you'll still see the dates on the x-axis. Or you can use an AsOf table as explained 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, 04 Jul 2014 08:37:52 GMT https://community.qlik.com/t5/QlikView/Do-not-plot-first-few-values-in-accumulation/m-p/708289#M1081391 Gysbert_Wassenaar 2014-07-04T08:37:52Z