topic Re: Backlog Chart for Open Orders in QlikView https://community.qlik.com/t5/QlikView/Backlog-Chart-for-Open-Orders/m-p/642454#M235366 <HTML><HEAD></HEAD><BODY><P>You may load island table with possible months. It will be dimension of your chart.</P><P>As a expression you may use something like this:</P><P></P><P>sum(if(open_date&lt;dim_date and close_date&gt;dim_date,Units))</P><P></P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Thu, 22 May 2014 08:31:53 GMT 2014-05-22T08:31:53Z Backlog Chart for Open Orders https://community.qlik.com/t5/QlikView/Backlog-Chart-for-Open-Orders/m-p/642453#M235365 <HTML><HEAD></HEAD><BODY><P>I have orders that are open for a given period of period of time and then eventually close when fullfilled.&nbsp; I need a chart to show the number of open units at any given month. </P><P></P><P>Example</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Creation Date&nbsp;&nbsp;&nbsp;&nbsp; Closed Date&nbsp;&nbsp;&nbsp;&nbsp; Units</P><P>Order 1&nbsp; 01/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>Order 2&nbsp; 01/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Open&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>Order 3&nbsp; 02/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>Order 4&nbsp; 02/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>The chart should like like this:</P><P>01/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15 units (5+10)</P><P>02/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 units (5+10+3+2)</P><P>03/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18 units (5+10+3)</P><P>04/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13 units (10+3)</P><P>05/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10 units</P></BODY></HTML> Wed, 21 May 2014 21:09:32 GMT https://community.qlik.com/t5/QlikView/Backlog-Chart-for-Open-Orders/m-p/642453#M235365 2014-05-21T21:09:32Z Re: Backlog Chart for Open Orders https://community.qlik.com/t5/QlikView/Backlog-Chart-for-Open-Orders/m-p/642454#M235366 <HTML><HEAD></HEAD><BODY><P>You may load island table with possible months. It will be dimension of your chart.</P><P>As a expression you may use something like this:</P><P></P><P>sum(if(open_date&lt;dim_date and close_date&gt;dim_date,Units))</P><P></P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Thu, 22 May 2014 08:31:53 GMT https://community.qlik.com/t5/QlikView/Backlog-Chart-for-Open-Orders/m-p/642454#M235366 2014-05-22T08:31:53Z Re: Backlog Chart for Open Orders https://community.qlik.com/t5/QlikView/Backlog-Chart-for-Open-Orders/m-p/642455#M235367 <HTML><HEAD></HEAD><BODY><P>Thank you so very much.&nbsp; Works exactly as expected!!</P></BODY></HTML> Thu, 22 May 2014 17:53:12 GMT https://community.qlik.com/t5/QlikView/Backlog-Chart-for-Open-Orders/m-p/642455#M235367 2014-05-22T17:53:12Z