Forecast for the next year

[pascos88]

Hi guys,

I would have a forecast on the next years, using the data that I already have.

I have the table of the sales:

Year      2000     2001     2002     2003 ....          2017     2018

Sales    255          289     355       400                2500        ?

There is a way to have this information,for istance with linear regression or some similar function in qlik sense?

Thanks for any helps..

Best

[sunny_talwar]

There are Linest_M and Linest_B functions

https://help.qlik.com/en-

US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/StatisticalAggregationFunctionsinC…‌

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/StatisticalAgg...

[pascos88]

Hi Sunny thanks for the answere.

Can u give me an exemple how you can use Linest_M in this case?

Just considering this 2 filds for exemple.

Thanks a lot

[sunny_talwar]

There is an example here... see if this helps... if not... I can help you

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/StatisticalAgg...