https://community.qlik.com/t5/QlikView/inventory-calculation/m-p/269981#M101225 <HTML><HEAD></HEAD><BODY><P>I have a Problem to solve in my Application for inventory calculation...</P><P></P><P>I have a Table like this:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Inventory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hours in Stock&nbsp;&nbsp;&nbsp; </P><P>Incoming&nbsp;&nbsp;&nbsp; 08:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>Outgoing&nbsp;&nbsp;&nbsp; 11:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03:00</P><P>Outgoing&nbsp;&nbsp;&nbsp;&nbsp; 15:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 07:00</P><P>Incoming</P><P></P><P>How i can calculate the "hours in Stock" and the "nventory" fields? </P></BODY></HTML> Mon, 24 Oct 2011 10:09:36 GMT 2011-10-24T10:09:36Z https://community.qlik.com/t5/QlikView/inventory-calculation/m-p/269981#M101225 <HTML><HEAD></HEAD><BODY><P>I have a Problem to solve in my Application for inventory calculation...</P><P></P><P>I have a Table like this:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Inventory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hours in Stock&nbsp;&nbsp;&nbsp; </P><P>Incoming&nbsp;&nbsp;&nbsp; 08:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>Outgoing&nbsp;&nbsp;&nbsp; 11:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03:00</P><P>Outgoing&nbsp;&nbsp;&nbsp;&nbsp; 15:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 07:00</P><P>Incoming</P><P></P><P>How i can calculate the "hours in Stock" and the "nventory" fields? </P></BODY></HTML> Mon, 24 Oct 2011 10:09:36 GMT https://community.qlik.com/t5/QlikView/inventory-calculation/m-p/269981#M101225 2011-10-24T10:09:36Z https://community.qlik.com/t5/QlikView/inventory-calculation/m-p/269982#M101226 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you make a manual result that you looking for?</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Mon, 24 Oct 2011 10:20:38 GMT https://community.qlik.com/t5/QlikView/inventory-calculation/m-p/269982#M101226 Sokkorn 2011-10-24T10:20:38Z https://community.qlik.com/t5/QlikView/inventory-calculation/m-p/269983#M101227 <HTML><HEAD></HEAD><BODY><P>i want to calculate inventory like this:</P><P></P><P>10 - outgoing(5) =5 - outgoing(2) =3 ..</P><P></P><P>and the "Hours in Stock " like:</P><P></P><P>08:00 to 11:00 = 03:00</P><P>08:00 to 15:00= 07:00</P></BODY></HTML> Mon, 24 Oct 2011 11:12:55 GMT https://community.qlik.com/t5/QlikView/inventory-calculation/m-p/269983#M101227 2011-10-24T11:12:55Z https://community.qlik.com/t5/QlikView/inventory-calculation/m-p/269984#M101228 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use function ABOVE().</P><P></P><P>Edit: Example for Inventory Expression: Inventory - ABOVE(Inventory)</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Mon, 24 Oct 2011 12:07:36 GMT https://community.qlik.com/t5/QlikView/inventory-calculation/m-p/269984#M101228 Sokkorn 2011-10-24T12:07:36Z