Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Is there a forecast function in Qlik like in Excel?

Hello Qlik Community,

    I just wanted to know if there is a forecast function like in Excel in Qlik?  If not directly, has anyone heard of a forecast plugin?  Thanks folks!

Nsikak

7 Replies
phaneendra_kunc
Valued Contributor III

Re: Is there a forecast function in Qlik like in Excel?

I dont think there a straight forward option in Qlik Sense. Where as we have an option in Qlikview.

See if you can mimic these in QLik Sense.

Pronostico de venta (Forecasting)

How to do Forecasting In Qlikview( with Example)

Not applicable

Re: Is there a forecast function in Qlik like in Excel?

Thank you Phaneendra, but I do not have Qlikview.  Could you post an example here?  Thanks a lot!

phaneendra_kunc
Valued Contributor III

Re: Is there a forecast function in Qlik like in Excel?

Do you have a sample app that i can use? Just upload a QVF with sample data.

Employee
Employee

Re: Is there a forecast function in Qlik like in Excel?

Hi Guys - Just trying to help out here.... I looked at the sample referenced in this post, and correct me if I am mistaken - but that example looks more like "what-if" analysis - as it is just multiplying a variable or user input to the price. Is that what the original poster is looking for?

Please verify,

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

phaneendra_kunc
Valued Contributor III

Re: Is there a forecast function in Qlik like in Excel?

Hi Mike,

Nope, user is looking to forecast the data. We usually use "linest" function in qlikview or in qlikview there is "Forecast/Backcast" options in line charts--> axes tab.

Nsikak wants to do the same using Qlik Sense. Something like you will have data lets say July 2016, but want to forecast the data until Dec 2016 meaning you need to project the data.

Not applicable

Re: Is there a forecast function in Qlik like in Excel?

Thank you Mike and Phaneendra, yes, Phaneendra has the correct idea.  We need to project data for future time.  Thanks.

Employee
Employee

Re: Is there a forecast function in Qlik like in Excel?

Awesome guys, great community effort and communication - greatly appreciated.