topic Re: How do i calculate Forecast in QlikView

How do i calculate Forecast

Wed, 27 May 2015 12:40:36 GMT

Hi All,

How do i calculate simple Forecast??

Supply any example you can as the simplest.

Please help out.

Regards:

Thabiso

Re: How do i calculate Forecast

john_s_w_wood — Wed, 27 May 2015 12:46:07 GMT

Hi Thabiso

Do you mean to use the built in trend lines on the Expressions tab of charts? There are also some basic statistical functions which may help e.g. LINEST* functions.

otherwise you may need to perform a statistical calculation as you load the main data (if you do not have a forecast data set somewhere to load along side)

Can you expand on your requirement please?

Re: How do i calculate Forecast

john_s_w_wood — Wed, 27 May 2015 12:47:23 GMT

ps Unfortunately you cannot get at some of the trendline formula as functions which is a bit of a shame (only LINEST)

Re: How do i calculate Forecast

Wed, 27 May 2015 12:54:20 GMT

Hi,

i have no idea on how to start please supply a simple Forecast on a straight table?

Thanks.

Re: How do i calculate Forecast

Wed, 27 May 2015 13:08:29 GMT

Hi,

Below is what i used to get Forecast, but it hides one of my Columns it makes it Null but with an answer on a Sum Expression

Sum( { <Year =, Month ={">=$(='201209') <=$(=max(Month))"}>} Records)