topic Re: Qlik - Forecasting Based on Previous Year in App Development

Qlik - Forecasting Based on Previous Year

psenthilbtech — Sat, 16 Nov 2024 17:46:03 GMT

I have a scenario, where i have to forecast the data based on the last Year Month Data. Below is the sample data

Qn : With the given data below - i need to forecast the data for Sep-20 till Dec - 2020 (Based on the Months Previous Year Data)

Ex: For Sept 2020 - I should get the value of Sept 2019, as i dont have the value for Sept 2018

For Oct 2020 - I should get the value of Oct 2019, as i dont have the value for OCt 2018

For Nov 2020 - I should get the Average value of Nov2019 and Nov 2018 and goes on

Regards,

chrismarlow — Fri, 27 Nov 2020 15:13:36 GMT

Hi,

If you just need to go back 2 years you could try using above function, so something like following might work;

(alt(above(Sum(Amount),12,0),0)+alt(above(Sum(Amount),24,0),0))/(alt(above(Count(Amount),12,0),0)+alt(above(Count(Amount),24,0),0))

Note you may need to do something different with the denominator (to decide if you are dividing by 1 or 2), depending on how your data is structured.

If you need to go back over time further as this rolls forward, suggest you look at this;

Cheers,

Chris.

ashok1203 — Sat, 28 Nov 2020 13:38:07 GMT

AT_7 — Fri, 15 Sep 2023 08:52:03 GMT

Can you post solution or script here instead of QVW . That will be really helpful