Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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