topic Forecast in QlikView in QlikView https://community.qlik.com/t5/QlikView/Forecast-in-QlikView/m-p/982834#M948539 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I am attempting to create a Sales Forecast using QlikView and basing forecast sales on the past 3 months actual sales.</P><P></P><P>i.e.</P><P></P><P>October Sales = 506</P><P>November Sales = 602</P><P>December Sales = 719</P><P></P><P>January should be = 609&nbsp;&nbsp; (506+602+719) / 3</P><P>February should be = 643 (602+719+609) / 3</P><P>March should be = 657 (719+609+643) / 3</P><P></P><P>I would like to plot this in a QlikView chart.</P><P></P><P>Any ideas will be greatly appreciated.</P></BODY></HTML> Thu, 24 Dec 2015 09:22:33 GMT 2015-12-24T09:22:33Z Forecast in QlikView https://community.qlik.com/t5/QlikView/Forecast-in-QlikView/m-p/982834#M948539 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I am attempting to create a Sales Forecast using QlikView and basing forecast sales on the past 3 months actual sales.</P><P></P><P>i.e.</P><P></P><P>October Sales = 506</P><P>November Sales = 602</P><P>December Sales = 719</P><P></P><P>January should be = 609&nbsp;&nbsp; (506+602+719) / 3</P><P>February should be = 643 (602+719+609) / 3</P><P>March should be = 657 (719+609+643) / 3</P><P></P><P>I would like to plot this in a QlikView chart.</P><P></P><P>Any ideas will be greatly appreciated.</P></BODY></HTML> Thu, 24 Dec 2015 09:22:33 GMT https://community.qlik.com/t5/QlikView/Forecast-in-QlikView/m-p/982834#M948539 2015-12-24T09:22:33Z Re: Forecast in QlikView https://community.qlik.com/t5/QlikView/Forecast-in-QlikView/m-p/982835#M948542 <HTML><HEAD></HEAD><BODY><P>PFA</P><P><BR />Red line - Forecast</P><P>Green line - Actual</P><P><IMG alt="aaa.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109936_aaa.png" style="height: auto;" /></P></BODY></HTML> Thu, 24 Dec 2015 11:31:49 GMT https://community.qlik.com/t5/QlikView/Forecast-in-QlikView/m-p/982835#M948542 tresB 2015-12-24T11:31:49Z Re: Forecast in QlikView https://community.qlik.com/t5/QlikView/Forecast-in-QlikView/m-p/982836#M948544 <HTML><HEAD></HEAD><BODY><P>Thank you.</P></BODY></HTML> Thu, 24 Dec 2015 13:52:00 GMT https://community.qlik.com/t5/QlikView/Forecast-in-QlikView/m-p/982836#M948544 2015-12-24T13:52:00Z