Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pascos88
Contributor

Forecast in QS

Hello, I would like to have some forecast, based on two count of the last two, three years.

I have years 2015 count 890

                    2016 count 1050

                    2017 count 1065

Now can I estimate count for 2018 basid on some function in qlik (regression or something else)?

I already know that there are function as LINEST, but how I should write the formula?

Thanks for any helps.

4 Replies
pascos88
Contributor

Re: Forecast in QS

no body have suggestions?

vikasmahajan
Honored Contributor III

Re: Forecast in QS

See attached app if this help.

Vikas

pascos88
Contributor

Re: Forecast in QS

Hi Vikas,

thanks for your answer, but how I can open a qvf file, if I have just Qlik Sense server?

Thanks a lot

tomasz_tru
Valued Contributor

Re: Forecast in QS

Use Desktop edition - it's free.

Tomasz

Community Browser