Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do Forecasting?

Hi Friends,

I've a data like as below

   

YearSales
20011000
20022000
20033000
20043500
20052000
20071500
20083000
20094500
2010

4000

I need to show the Sales value in line chart up to 2012 by forecasting Can you please help me how to do this..

5 Replies
avinashelite

We don't have a complete dynamic forcasting method in Qlikview but if you go the Axis tab you have the option like Forcast you can use this option ....other than this you need to prepare the data and need to feed the same for Qlikview.

Anonymous
Not applicable
Author

See the attachment, Forcasting using What If in QV

Not applicable
Author

I already used that expression but I didn't get can you please share me any step by step docs if u ve means..

Not applicable
Author

ji I can't open that file till now am using personal edition only.

so can you please tell me how to do in step by step..

HirisH_V7
Master
Master

Hi,

You can do ForeCast according Your data,

If You require another Five years,Fore cast means,

Under Axes Tab ->At Forecast  use an integer 5  -> Dimension Axes as Continuous

Under Expression Tab ->Select your Expression -> Trendlines -> There  you can select as per your requirement ->

  • Average
  • Linear
  • Polynomial
  • Exponential

Forcasting using Forcast -203770.PNG

Similarly for BackCast too.

Hope this helps,

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”