Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Supply Demand Matching using Qlik Sense

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).

Step2Smiley SadI 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.