topic Re: forecasting expression in QlikView

forecasting expression

didierodayo — Wed, 21 Sep 2016 10:13:36 GMT

Hello,

I need some help with the sample table below, I am trying to get on what date the level will hit 100 which is the highest level or more.

I need to know how to write the script to populate the Estimated_highlvl_Date.

I have attached the excel sample as well.

Your help is appreciated

Thanks

sunny_talwar — Wed, 21 Sep 2016 10:36:11 GMT

How would be the estimate the rate of increase? I mean based on what criteria?

didierodayo — Wed, 21 Sep 2016 10:51:29 GMT

Hi Sunny,

I would like it based first on :

given the level is at x rate in y number of months/days it will hit the highest level or more by DATE???

That is the sort of concept am building in my mind I don't know if it is clear ?

effinty2112 — Wed, 21 Sep 2016 11:21:18 GMT

Hi Didier,

If we assume a linear model for the increase over time then using regression analysis:

=Date((100-LINEST_B(level,DATE))/LINEST_M(level,DATE))

gives a date of 9th Jan 2016 as the forecast of when level reaches 100.

Hope this helps.

Cheers

Andrew

didierodayo — Wed, 21 Sep 2016 11:27:26 GMT

Thanks Andrew, that is what I am trying to represent.