Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pascos88
Contributor

Forecast for the next year

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

3 Replies
pascos88
Contributor

Re: Forecast for the next year

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

MVP
MVP

Re: Forecast for the next year

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...

Community Browser