topic Re: Forecast the sales figure for the month of December(12th month) in QlikView

Forecast the sales figure for the month of December(12th month)

srishsum2017 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Please suggest the solution for Forecasting the sales figure for the month of December(12th month) with below data

Thanks in advance

varshavig12 — Mon, 16 Jan 2017 04:08:31 GMT

Hi Sumit,

I haven't used the forecast feature.

Check the below link:

Try this in your exp:

=if(Month<>'12',sum([Sales in Rs]),

linest_m(total aggr(if(sum(Value),sum(Value)),Month),Month)*Month

+linest_b(total aggr(if(sum(Value),sum(Value)),Month),Month))

srishsum2017 — Sat, 21 Jan 2017 02:19:55 GMT

Thanks for the replying it is helpful for me