0 Replies Latest reply: Aug 31, 2016 3:12 PM by Arunkishore Ramgopal RSS

    Supply Demand Matching using Qlik Sense

    Arunkishore Ramgopal

      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.