Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis to limit visible rolling accumulated values

Hi,

I have created a line graph with rolling 13 weeks values. My problem is that there is a 13 weeks ramp up before the graph shows a full rolling value. I want to limit the visible part of the calculation to after the 13 weeks ramp up.  Is there a way to achive this? I found the folling thread describing a similar problem and with a solution: http://community.qlik.com/message/316593#316593.

Attached you find the file I'm working in. The data is broken down in more details (per item number, customer order lines and dates) and I want to keep this structure to be able to view the details easy. The grey line is the correct calculation and what I want to achieve is the same values but only for a limit week range e.g. the black line (with  calculation error). The table might help to understand the calculations.

I hope you can help!

Thanks alot!

Erik

0 Replies