11 Replies Latest reply: Jun 19, 2017 1:07 PM by Tristen Hannah RSS

    Create a forecast based on seasonal curve and historical data

    Tristen Hannah

      Hi, I am tracking data that is seasonal with some fluctuations.  I'd like to have my seasonal model as a table in Qlik Sense and update actual as they come in.  As new actuals are added, would like to automatically update the forecast based on the predefined curve.

       

      qlikq4.PNG

       

      Blue line, right axis is the seasonal curve.  Orange/left is actual data.  Integral under the blue curve is 1 (100% of the seasons volume).  What I want is to sum the last four data points of actuals, divide by the sum of the corresponding four points of curve, and use that factor to multiply the curve going forward, creating an estimate line:

       

      qlikq5.PNG

       

      Any ideas on how to approach this?