topic Inventory difference within a period in QlikView https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154170#M30886 <HTML><HEAD></HEAD><BODY><P>Can anyone help, please?</P></BODY></HTML> Thu, 25 Feb 2010 14:38:25 GMT 2010-02-25T14:38:25Z Inventory difference within a period https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154167#M30883 <HTML><HEAD></HEAD><BODY><P>Could anyone help with this, supposedly, easy exercise? I've got an sql table containing inventory values at certain pointrs of time e.g.:</P><P style="padding-left: 30px;">Date, Value</P><P style="padding-left: 30px;">2009-01-01, 10</P><P style="padding-left: 30px;">2009-06-30, 9</P><P style="padding-left: 30px;">2009-12-31, 12</P><P style="padding-left: 30px;">2010-01-01, 7</P><P>and would like to find difference between the last and the first within a period to get:</P><P style="padding-left: 30px;">-1 for 01-06.2009</P><P style="padding-left: 30px;">2 for 01-12.2009</P><P style="padding-left: 30px;">0 for 01-12.2010 (one record is the first and the last at the same time)</P><P>Due to the complexity of the rest of the script I need to set it within sql code.</P><P>Thanks, Przemek</P></BODY></HTML> Sat, 20 Feb 2010 22:34:39 GMT https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154167#M30883 2010-02-20T22:34:39Z Inventory difference within a period https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154168#M30884 <HTML><HEAD></HEAD><BODY><P>I am cofused with your sample data and result. Could you please double check and explain little further?</P></BODY></HTML> Sat, 20 Feb 2010 23:45:13 GMT https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154168#M30884 disqr_rm 2010-02-20T23:45:13Z Inventory difference within a period https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154169#M30885 <HTML><HEAD></HEAD><BODY><P>Done. It should make sense now.</P></BODY></HTML> Sun, 21 Feb 2010 09:41:17 GMT https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154169#M30885 2010-02-21T09:41:17Z Inventory difference within a period https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154170#M30886 <HTML><HEAD></HEAD><BODY><P>Can anyone help, please?</P></BODY></HTML> Thu, 25 Feb 2010 14:38:25 GMT https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154170#M30886 2010-02-25T14:38:25Z Inventory difference within a period https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154171#M30887 <HTML><HEAD></HEAD><BODY><P>Anyone any idea, please?</P></BODY></HTML> Wed, 03 Mar 2010 16:25:33 GMT https://community.qlik.com/t5/QlikView/Inventory-difference-within-a-period/m-p/154171#M30887 2010-03-03T16:25:33Z