Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (1)
7 Replies
marcus_malinow
Valued Contributor II

Re: Forecast line chart

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
Honored Contributor II

Re: Forecast line chart

brunobertels
Valued Contributor

Re: Forecast line chart

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

Re: Forecast line chart

Hi Bruno,

Predicted based on sum measure of last 10 years.

Regards,

Roman

brunobertels
Valued Contributor

Re: Forecast line chart

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

Re: Forecast line chart

Simple trend line based on random data.

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

danielgargiulo
New Contributor III

Re: Forecast line chart

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

Community Browser