Discussion board where members can get started with Qlik Sense.
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?
Pronostico de venta (Forecasting)
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
Predicted based on sum measure of last 10 years.
May I sucgest you to post a sample of your data and details about your requierments, so the community could help you.
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.