topic Supply Demand Matching using Qlik Sense in App Development https://community.qlik.com/t5/App-Development/Supply-Demand-Matching-using-Qlik-Sense/m-p/1124684#M19552 <HTML><HEAD></HEAD><BODY><P>I am looking to create a supply demand matching app in Qlik Sense. I have</P><P>Forecasted demand - By Product, By Period, By region</P><P>Supply Plan - By Product, By Period, By region</P><P>Inventory - Beginning On Hand (BOH) inventory by product, by region</P><P></P><P>Step1: (I have done this part is it is a straight forward loading data and calculating EOH)</P><P>Current quarter BOH should be actuals from inventory file, Demand and supply for all quarters is fed from source data. Ending On Hand should be calculated&nbsp; using (BOH+Supply-Demand). </P><P>Step2:(I am not sure how to do this)</P><P>Next/subsequent quarter: BOH = EOH calculated from previous quarter.</P><P></P><P>Attached is the sheet with sample data and sample of the output I am looking for.</P></BODY></HTML> Wed, 31 Aug 2016 19:12:32 GMT 2016-08-31T19:12:32Z Supply Demand Matching using Qlik Sense https://community.qlik.com/t5/App-Development/Supply-Demand-Matching-using-Qlik-Sense/m-p/1124684#M19552 <HTML><HEAD></HEAD><BODY><P>I am looking to create a supply demand matching app in Qlik Sense. I have</P><P>Forecasted demand - By Product, By Period, By region</P><P>Supply Plan - By Product, By Period, By region</P><P>Inventory - Beginning On Hand (BOH) inventory by product, by region</P><P></P><P>Step1: (I have done this part is it is a straight forward loading data and calculating EOH)</P><P>Current quarter BOH should be actuals from inventory file, Demand and supply for all quarters is fed from source data. Ending On Hand should be calculated&nbsp; using (BOH+Supply-Demand). </P><P>Step2:(I am not sure how to do this)</P><P>Next/subsequent quarter: BOH = EOH calculated from previous quarter.</P><P></P><P>Attached is the sheet with sample data and sample of the output I am looking for.</P></BODY></HTML> Wed, 31 Aug 2016 19:12:32 GMT https://community.qlik.com/t5/App-Development/Supply-Demand-Matching-using-Qlik-Sense/m-p/1124684#M19552 2016-08-31T19:12:32Z