topic Creating A Forecast Chart! in QlikView https://community.qlik.com/t5/QlikView/Creating-A-Forecast-Chart/m-p/276550#M1179461 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>How can I create a Sales Forecast chart (showing current sales (have data until 2011) and forecast of next year (say 2012)&nbsp; in my QV document. I have YearForecast and Sales as dimensions.</P><P></P><P>Help appreciated.</P><P></P><P>Thanks.</P></BODY></HTML> Sat, 14 Jan 2012 06:36:51 GMT 2012-01-14T06:36:51Z Creating A Forecast Chart! https://community.qlik.com/t5/QlikView/Creating-A-Forecast-Chart/m-p/276550#M1179461 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>How can I create a Sales Forecast chart (showing current sales (have data until 2011) and forecast of next year (say 2012)&nbsp; in my QV document. I have YearForecast and Sales as dimensions.</P><P></P><P>Help appreciated.</P><P></P><P>Thanks.</P></BODY></HTML> Sat, 14 Jan 2012 06:36:51 GMT https://community.qlik.com/t5/QlikView/Creating-A-Forecast-Chart/m-p/276550#M1179461 2012-01-14T06:36:51Z Creating A Forecast Chart! https://community.qlik.com/t5/QlikView/Creating-A-Forecast-Chart/m-p/276551#M1179462 <HTML><HEAD></HEAD><BODY><P>Hi Khaled</P><P></P><P>Use the time as your dimension, then you need to enter two expressions, one for the forecast, one for the actual sales.</P><P>EG dimension = month</P><P>expr1 = sum(Sales)</P><P>expr2 = sum(YearForecast)</P><P></P><P>is this what you need?</P><P></P><P>Regards,</P><P></P><P>Erica</P></BODY></HTML> Sun, 15 Jan 2012 09:55:19 GMT https://community.qlik.com/t5/QlikView/Creating-A-Forecast-Chart/m-p/276551#M1179462 2012-01-15T09:55:19Z Creating A Forecast Chart! https://community.qlik.com/t5/QlikView/Creating-A-Forecast-Chart/m-p/276552#M1179463 <HTML><HEAD></HEAD><BODY><P> Thanks Erica. It worked.</P></BODY></HTML> Mon, 30 Jan 2012 07:34:35 GMT https://community.qlik.com/t5/QlikView/Creating-A-Forecast-Chart/m-p/276552#M1179463 2012-01-30T07:34:35Z