Forecasting

[Anonymous]

Hello Community,

  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:

  I'd like to have like 3 or 4 months more to the right, could it be possible?

  Thanks in advance!

[sunny_talwar]

May be using Linest_M and Linest_B functions

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/StatisticalAggreg...

[Frank_Hartmann]

hi,

have a look at the attached sample!

hope this helps

[Anonymous]

Hello Frank,

  Can you please share your XLS file?

[Frank_Hartmann]

Here you go.

hope this helps