Set analysis to limit visible rolling accumulated values

Fri, 01 Mar 2013 10:15:53 GMT

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

topic Set analysis to limit visible rolling accumulated values in QlikView

Set analysis to limit visible rolling accumulated values