topic Forecasting 12 month in QlikView https://community.qlik.com/t5/QlikView/Forecasting-12-month/m-p/467097#M560838 <HTML><HEAD></HEAD><BODY><P>Hi - </P><P></P><P>I have not used the forecasting feature that QV offers and i was hoping you can help with the following sneario. </P><P></P><P>I am looking to build a report that will project monthly sales. If I was to build this out in a simple excel formula, it would look like something like this:</P><P></P><P><STRONG>Fiscal Period&nbsp;&nbsp;&nbsp;&nbsp; Total Sale&nbsp; Forecasting Formula <SPAN style="color: #ff0000;"> Period 2 2013 </SPAN></STRONG><STRONG style="color: #ff0000;">Period 3 2013 </STRONG><STRONG style="color: #ff0000;">Period 4 2013 </STRONG></P><P>Period 1 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120/12=10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.00 etc </P><P><STRONG>Balance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90 etc&nbsp;&nbsp; </STRONG></P><P></P><P></P><P><STRONG>Please help, thank you!<BR /></STRONG></P></BODY></HTML> Thu, 18 Apr 2013 11:56:39 GMT 2013-04-18T11:56:39Z Forecasting 12 month https://community.qlik.com/t5/QlikView/Forecasting-12-month/m-p/467097#M560838 <HTML><HEAD></HEAD><BODY><P>Hi - </P><P></P><P>I have not used the forecasting feature that QV offers and i was hoping you can help with the following sneario. </P><P></P><P>I am looking to build a report that will project monthly sales. If I was to build this out in a simple excel formula, it would look like something like this:</P><P></P><P><STRONG>Fiscal Period&nbsp;&nbsp;&nbsp;&nbsp; Total Sale&nbsp; Forecasting Formula <SPAN style="color: #ff0000;"> Period 2 2013 </SPAN></STRONG><STRONG style="color: #ff0000;">Period 3 2013 </STRONG><STRONG style="color: #ff0000;">Period 4 2013 </STRONG></P><P>Period 1 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120/12=10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.00 etc </P><P><STRONG>Balance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90 etc&nbsp;&nbsp; </STRONG></P><P></P><P></P><P><STRONG>Please help, thank you!<BR /></STRONG></P></BODY></HTML> Thu, 18 Apr 2013 11:56:39 GMT https://community.qlik.com/t5/QlikView/Forecasting-12-month/m-p/467097#M560838 2013-04-18T11:56:39Z