Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Do not plot first few values in accumulation

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?

rolling 4 weeks.png

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

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: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand