topic Re: Rolling Month Forecast in QlikView

Rolling Month Forecast

Anonymous — Tue, 20 Dec 2016 07:40:38 GMT

Hi,

I need help with creating a Month Rolling Forecast for 36 Months. I have 23 Months Actuals and would like to create a Forecast for the remaining 13 months using the Previous and Cuurent Year's Actuals. My first Year 2015, has 12 Months Actuals, My second Year 2016 has 11 Months Actuals. I want to calculate my Forecast from December 2016 to December 2017. In the end I want to have 36 Months.

My formula is a follows:

December 2016 [ (November 2015/October 2015)*November 2015

I don't know how to do this in Qlikview, please help.

Regards,

Selby

Note: Title edited by Community Moderator to reflect topic

Re: Rolling Month Forecast

enriquem — Tue, 20 Dec 2016 16:40:27 GMT

Do you try to create a calendar dimension with the maximum date and the next 13 months??

With this you will have 36 months and then you must create the expresion to calculate de forecast values of your data.

Regards

Re: Rolling Month Forecast

Anonymous — Tue, 20 Dec 2016 17:58:39 GMT

Hi Enrique,

Thank you for your quick response.

I have the calendar with the dimensions, the problem is that I can only show the 23 months actuals on the pivot table but I don't know how to calculate the 13 months forecast from the actuals and show the whole 36 months on the pivot table.

Regards,

Selby