Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need create line chart where will be actual measure value and predicted for next two years.
How I can do this
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?
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
Hi Bruno,
Predicted based on sum measure of last 10 years.
Regards,
Roman
Hi
May I sucgest you to post a sample of your data and details about your requierments, so the community could help you.
Bruno
Simple trend line based on random data.
Not aware of a "built-in" forecast option like QlikView, in QlikSense.
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
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/