topic Expression showing forecasted stock levels in QlikView https://community.qlik.com/t5/QlikView/Expression-showing-forecasted-stock-levels/m-p/618752#M1101695 <HTML><HEAD></HEAD><BODY><P>I need to create a table chart showing our forecasted stock levels at a selected date.</P><P></P><P>The fields I have acces to is:</P><P></P><P>Part_No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (our item number)</P><P>CurrentStock&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Our current stock level)</P><P>Transactiondate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Date of forecasted transaction)</P><P>Transaction_type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ( Supply or demand)</P><P>Qty_supply (forecasted supply at a given date)</P><P>Qty_demand (forecasted demand at a given date)</P><P></P><P>I want to write an expression that can show me the stock levels at any given transaction date.</P><P>CurrentStock+Qty_Supply-Qty_demand</P><P></P><P>Could any body help me with this expression?</P><P></P><P>Perhaps pritty simple but I do not pretend to be an expert on this and would appriciate the help....</P></BODY></HTML> Wed, 09 Apr 2014 11:06:42 GMT 2014-04-09T11:06:42Z Expression showing forecasted stock levels https://community.qlik.com/t5/QlikView/Expression-showing-forecasted-stock-levels/m-p/618752#M1101695 <HTML><HEAD></HEAD><BODY><P>I need to create a table chart showing our forecasted stock levels at a selected date.</P><P></P><P>The fields I have acces to is:</P><P></P><P>Part_No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (our item number)</P><P>CurrentStock&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Our current stock level)</P><P>Transactiondate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Date of forecasted transaction)</P><P>Transaction_type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ( Supply or demand)</P><P>Qty_supply (forecasted supply at a given date)</P><P>Qty_demand (forecasted demand at a given date)</P><P></P><P>I want to write an expression that can show me the stock levels at any given transaction date.</P><P>CurrentStock+Qty_Supply-Qty_demand</P><P></P><P>Could any body help me with this expression?</P><P></P><P>Perhaps pritty simple but I do not pretend to be an expert on this and would appriciate the help....</P></BODY></HTML> Wed, 09 Apr 2014 11:06:42 GMT https://community.qlik.com/t5/QlikView/Expression-showing-forecasted-stock-levels/m-p/618752#M1101695 2014-04-09T11:06:42Z