topic Re: Re: Forecasting or Predicting Sales for next one Month or Year in QlikView

Forecasting or Predicting Sales for next one Month or Year

Wed, 02 Apr 2014 07:39:48 GMT

Hi All,

I have a line chart with data.

I want to Predict the next one month Sales based on the Current Sales.

Can we do it in Qlikview ??

I want the Predictive data to be displayed in Dotted Lines

Thanks & Regards,

Keerthi

Re: Forecasting or Predicting Sales for next one Month or Year

Wed, 02 Apr 2014 07:42:36 GMT

Hi Keerthi

Try Chart Properties => Axes => Forecast

Lukasz

Re: Forecasting or Predicting Sales for next one Month or Year

Wed, 02 Apr 2014 07:45:36 GMT

Please tell me in detail.

Re: Forecasting or Predicting Sales for next one Month or Year

Wed, 02 Apr 2014 07:49:12 GMT

from QlikView reference:

Backcast This function operates on trend lines. Enter into the text edit box how far back

you would like to estimate the trend line. The backcast portion of trend lines is displayed as dotted.

Forecast Enter into the text edit box how far you wish to predict the trend line. The forecast portion of trend lines is displayed as dotted.

Re: Forecasting or Predicting Sales for next one Month or Year

Wed, 02 Apr 2014 07:53:31 GMT

Can you send an example ??

Re: Re: Forecasting or Predicting Sales for next one Month or Year

Wed, 02 Apr 2014 07:58:06 GMT

It's all up to trendline you want to use, but with linear trendline it would be something like in attached document

Re: Forecasting or Predicting Sales for next one Month or Year

mangalsk — Wed, 02 Apr 2014 08:16:23 GMT

Hello,

You want like following:

Create a variable vWhatIf and use it in slider

For slider use following setting

in expression use

1st expression:sum(sales)

2nd expression for forecast:(sum(sales* (1 + vWhatIf))

Regards

Re: Forecasting or Predicting Sales for next one Month or Year

Wed, 02 Apr 2014 08:38:57 GMT

Hi,

As you told, you like to display predicted data on the chart. So, i thing trendline and forecast will not be good solution in your case. I think you should rather calculate your prediction in load script or in expressions, depending if your prediction algorithm depends less or more on user selections.

regards

Darek