0 Replies Latest reply: Mar 1, 2013 5:15 AM by Erik Videsson RSS

    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