topic Line Chart with Accumulation up and down? in QlikView https://community.qlik.com/t5/QlikView/Line-Chart-with-Accumulation-up-and-down/m-p/687287#M539861 <HTML><HEAD></HEAD><BODY><P>I am looking to create a chart that shows numbers of open orders by date.</P><P>I have 3 fields for each order - order open date, order closed date and a counter. I can produce a chart that shows the numbers of orders increasing, by setting the x axis to Order Open Date. and the y axis as count(Counter) with Full Accumulation.</P><P>I would like to incorporate the Order Closed Date so that the line chart goes down as well as up, during quieter and busier periods.</P><P>Any suggestions would be welcome.</P></BODY></HTML> Fri, 15 Aug 2014 13:54:34 GMT 2014-08-15T13:54:34Z Line Chart with Accumulation up and down? https://community.qlik.com/t5/QlikView/Line-Chart-with-Accumulation-up-and-down/m-p/687287#M539861 <HTML><HEAD></HEAD><BODY><P>I am looking to create a chart that shows numbers of open orders by date.</P><P>I have 3 fields for each order - order open date, order closed date and a counter. I can produce a chart that shows the numbers of orders increasing, by setting the x axis to Order Open Date. and the y axis as count(Counter) with Full Accumulation.</P><P>I would like to incorporate the Order Closed Date so that the line chart goes down as well as up, during quieter and busier periods.</P><P>Any suggestions would be welcome.</P></BODY></HTML> Fri, 15 Aug 2014 13:54:34 GMT https://community.qlik.com/t5/QlikView/Line-Chart-with-Accumulation-up-and-down/m-p/687287#M539861 2014-08-15T13:54:34Z Re: Line Chart with Accumulation up and down? https://community.qlik.com/t5/QlikView/Line-Chart-with-Accumulation-up-and-down/m-p/687288#M539862 <HTML><HEAD></HEAD><BODY><P>That is a lot easier to do when you first generate a table with records for each day between the open and closed date for each order. See this blog post: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Creating Reference Dates for Intervals</A></P></BODY></HTML> Fri, 15 Aug 2014 13:58:19 GMT https://community.qlik.com/t5/QlikView/Line-Chart-with-Accumulation-up-and-down/m-p/687288#M539862 Gysbert_Wassenaar 2014-08-15T13:58:19Z Re: Line Chart with Accumulation up and down? https://community.qlik.com/t5/QlikView/Line-Chart-with-Accumulation-up-and-down/m-p/687289#M539863 <HTML><HEAD></HEAD><BODY><P>This looks good so far, but I have 1 issue.</P><P></P><P>What if there is no ToDate, as an order is still open? Will it still count the order as open today?</P></BODY></HTML> Mon, 18 Aug 2014 13:49:10 GMT https://community.qlik.com/t5/QlikView/Line-Chart-with-Accumulation-up-and-down/m-p/687289#M539863 2014-08-18T13:49:10Z Re: Line Chart with Accumulation up and down? https://community.qlik.com/t5/QlikView/Line-Chart-with-Accumulation-up-and-down/m-p/687290#M539864 <HTML><HEAD></HEAD><BODY><P>Generate the days until the ToDate value or if it's missing until the value of Today(). </P></BODY></HTML> Mon, 18 Aug 2014 13:53:41 GMT https://community.qlik.com/t5/QlikView/Line-Chart-with-Accumulation-up-and-down/m-p/687290#M539864 Gysbert_Wassenaar 2014-08-18T13:53:41Z