topic Re: Forecasting in QlikView https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289906#M403482 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>have a look at the attached sample!</P><P>hope this helps</P></BODY></HTML> Tue, 14 Mar 2017 19:54:56 GMT Frank_Hartmann 2017-03-14T19:54:56Z Forecasting https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289904#M403480 <HTML><HEAD></HEAD><BODY><P>Hello Community,</P><P></P><P>&nbsp; I'm trying to use Forecast option in my chart, but I don't know if it is possible to extend the x-axis with the "forecasted" values and months. I have something like this:</P><P></P><P><IMG alt="Graficoqv.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156282_Graficoqv.png" style="height: auto;" /></P><P></P><P>&nbsp; I'd like to have like 3 or 4 months more to the right, could it be possible?</P><P></P><P>&nbsp; Thanks in advance!</P></BODY></HTML> Tue, 14 Mar 2017 18:29:23 GMT https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289904#M403480 Anonymous 2017-03-14T18:29:23Z Re: Forecasting https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289905#M403481 <HTML><HEAD></HEAD><BODY><P>May be using Linest_M and Linest_B functions</P><P><A href="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest-example.htm" title="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest-example.htm">https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinChar…</A></P></BODY></HTML> Tue, 14 Mar 2017 18:55:07 GMT https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289905#M403481 sunny_talwar 2017-03-14T18:55:07Z Re: Forecasting https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289906#M403482 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>have a look at the attached sample!</P><P>hope this helps</P></BODY></HTML> Tue, 14 Mar 2017 19:54:56 GMT https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289906#M403482 Frank_Hartmann 2017-03-14T19:54:56Z Re: Forecasting https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289907#M403483 <HTML><HEAD></HEAD><BODY><P>Hello Frank,</P><P></P><P>&nbsp; Can you please share your XLS file?</P></BODY></HTML> Wed, 15 Mar 2017 20:19:55 GMT https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289907#M403483 Anonymous 2017-03-15T20:19:55Z Re: Forecasting https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289908#M403484 <HTML><HEAD></HEAD><BODY><P>Here you go.</P><P>hope this helps</P></BODY></HTML> Thu, 16 Mar 2017 08:46:25 GMT https://community.qlik.com/t5/QlikView/Forecasting/m-p/1289908#M403484 Frank_Hartmann 2017-03-16T08:46:25Z