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 Current 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