Forecast line chart

[#1]

Hi All,

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

How I can do this

[marcus_malinow]

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]

See this

Pronostico de venta (Forecasting)

https://community.qlik.com/docs/DOC-3555

[brunobertels]

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

[#5]

Hi Bruno,

Predicted based on sum measure of last 10 years.

Regards,

Roman

[brunobertels]

Hi

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

Bruno

[#7]

Simple trend line based on random data.

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

[danielgargiulo]

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]

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/