topic Forecasting Expression in QlikView https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143053#M374277 <HTML><HEAD></HEAD><BODY><P>All, I have a simple bar chart with 4 years of data, and I want to add an additional 5 years of forecasting data. Any advice. This is just dummy data for a demo, so as long as I can show something that's fine. </P><P></P><P></P><P>Year = [Service Year]</P><P>Spend = Sum([Total Spend])</P><P></P><P></P><P><IMG alt="Forecast bar Chart.png" class="jive-image image-1" src="/legacyfs/online/131058_Forecast bar Chart.png" style="height: 306px; width: 620px;" /></P></BODY></HTML> Tue, 12 Jul 2016 21:01:37 GMT 2016-07-12T21:01:37Z Forecasting Expression https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143053#M374277 <HTML><HEAD></HEAD><BODY><P>All, I have a simple bar chart with 4 years of data, and I want to add an additional 5 years of forecasting data. Any advice. This is just dummy data for a demo, so as long as I can show something that's fine. </P><P></P><P></P><P>Year = [Service Year]</P><P>Spend = Sum([Total Spend])</P><P></P><P></P><P><IMG alt="Forecast bar Chart.png" class="jive-image image-1" src="/legacyfs/online/131058_Forecast bar Chart.png" style="height: 306px; width: 620px;" /></P></BODY></HTML> Tue, 12 Jul 2016 21:01:37 GMT https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143053#M374277 2016-07-12T21:01:37Z Re: Forecasting Expression https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143054#M374278 <HTML><HEAD></HEAD><BODY><P>What exactly are you aiming to do here? What is the plan, can you elaborate may be? and provide a sample?</P></BODY></HTML> Wed, 13 Jul 2016 02:13:31 GMT https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143054#M374278 sunny_talwar 2016-07-13T02:13:31Z Re: Forecasting Expression https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143055#M374279 <HTML><HEAD></HEAD><BODY><P>Its complex when you need a accurate forecasting, but for demonstration, why not add a trend line on the graph? It seems easier! Just right click the chart to find it out!</P></BODY></HTML> Wed, 13 Jul 2016 04:26:15 GMT https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143055#M374279 2016-07-13T04:26:15Z Re: Forecasting Expression https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143056#M374280 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><A href="https://community.qlik.com/thread/29814">Prediction function in QlikView</A></P></BODY></HTML> Wed, 13 Jul 2016 05:08:08 GMT https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143056#M374280 ajsjoshua 2016-07-13T05:08:08Z Re: Forecasting Expression https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143057#M374281 <HTML><HEAD></HEAD><BODY><P>Thanks all, but I found an alternative. </P></BODY></HTML> Wed, 13 Jul 2016 21:01:57 GMT https://community.qlik.com/t5/QlikView/Forecasting-Expression/m-p/1143057#M374281 2016-07-13T21:01:57Z