I am looking to create a supply demand matching app in Qlik Sense. I have
Forecasted demand - By Product, By Period, By region
Supply Plan - By Product, By Period, By region
Inventory - Beginning On Hand (BOH) inventory by product, by region
Step1: (I have done this part is it is a straight forward loading data and calculating EOH)
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 using (BOH+Supply-Demand).
Step2:(I am not sure how to do this)
Next/subsequent quarter: BOH = EOH calculated from previous quarter.
Attached is the sheet with sample data and sample of the output I am looking for.