topic Month Rolling Forecast in QlikView https://community.qlik.com/t5/QlikView/Month-Rolling-Forecast/m-p/1216745#M389621 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need help with creating a Month Rolling Forecast for 36 Months. I have 23 Months Actuals and would like to create a Forecast&nbsp; 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.</P><P></P><P>My formula is a follows:</P><P></P><P>December 2016 [ (November 2015/October 2015)*November 2015</P><P></P><P>I don't know how to do this in Qlikview, please help.</P><P></P><P>Regards,</P><P>Selby</P></BODY></HTML> Wed, 21 Dec 2016 13:30:11 GMT Anonymous 2016-12-21T13:30:11Z Month Rolling Forecast https://community.qlik.com/t5/QlikView/Month-Rolling-Forecast/m-p/1216745#M389621 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need help with creating a Month Rolling Forecast for 36 Months. I have 23 Months Actuals and would like to create a Forecast&nbsp; 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.</P><P></P><P>My formula is a follows:</P><P></P><P>December 2016 [ (November 2015/October 2015)*November 2015</P><P></P><P>I don't know how to do this in Qlikview, please help.</P><P></P><P>Regards,</P><P>Selby</P></BODY></HTML> Wed, 21 Dec 2016 13:30:11 GMT https://community.qlik.com/t5/QlikView/Month-Rolling-Forecast/m-p/1216745#M389621 Anonymous 2016-12-21T13:30:11Z