Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Forecasting or Predicting Sales for next one Month or Year

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,


7 Replies
Not applicable

Hi Keerthi

Try Chart Properties => Axes => Forecast


Not applicable

Please tell me in detail.

Not applicable

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.

Not applicable

Can you send an example ??

Not applicable

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

Creator III
Creator III


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))


Not applicable


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.