Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Forecast line chart

Hi All,

I need create line chart where will be actual measure value and predicted for next two years.

How I can do this

8 Replies
marcus_malinow
Specialist III
Specialist III

Ok, so you have loaded the data here into your document?

If so, do you have a calendar set up?

What are the names of the fields for your actual and forecast values?

ecolomer
Master II
Master II

brunobertels
Specialist II
Specialist II

Hi Roman

predicted for next 2 years, based on witch values ? Average mesure of last 3 or 6 ou 12 months ?

Or based on variable to put , for exemple change price for next year?

Have a look to "What IF analysis " in the forum

This may help you

Regards

Bruno

Not applicable
Author

Hi Bruno,

Predicted based on sum measure of last 10 years.

Regards,

Roman

brunobertels
Specialist II
Specialist II

Hi

May I sucgest you to post a sample of your data and details about your requierments, so the community could help you.

Bruno

Not applicable
Author

Simple trend line based on random data.

Not aware of a "built-in" forecast option like QlikView, in QlikSense.

danielgargiulo
Partner
Partner

i have attached an updated version of the QVF above. The updated version removes the zero values in the future for the actual series.

cheers.

Dan

cookiejest
Partner
Partner

Hey you can try out this free Qlik Sense preditive line chart extension.

 

It uses ARIMA method to do the forecast dynamically..

 

https://blog.webofwork.com/predictive-line-chart-for-qlik-sense/