Forecasting future months for measure

[Daryn]

Hello, 

Seasons greetings to you all.

I have added future months to my master calendar (for now just next 3 months).

I have an existing measure giving a single value per month (up until end of previous month) and would like to forecast it for the next 3 months.

I tried with an rangeavg:

Rangeavg(Above(Sum({<[Date.autoCalendar.MonthsAgo]={">=1<=3"}>} [Current Month Price]),0, 3))

But I get what looks to be an unrealistic value repeated for the first two months).

My values in a table are:

(exported and attached).

Any help would be appreciated. I don't mind what type of forecast is generated for now (as I can expand on it).

I am happy to do this in the front or backend, pending your advice/expertise!

Regards Daryn

[Daniel_Pilla]

Hi @Daryn ,

Are you in Qlik Cloud? If so, are you opposed to using the native forecasting feature? You can toggle it on under the Measure controls, then control the dimensional values under the Dimension controls after enabling it.

Otherwise, you will have to force show the dimensional values (with something like `<measure> + Sum({1}0)` and use an algorithm to calculate it.

Alternatively, you could use a server-side extension, though this is more complex.

I hope this helps-

Cheers,

[Daryn]

Hi,
Many thanks for taking the time to read and respond.
We are using Qlik sense, So unfortunately, the cloud solution is unavailable to me at present.
I am now on annual leave, so won’t pick this up until my return to the office at the beginning of January.
Thank you again, appreciated.
Daryn