Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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..

Tags (1)
5 Replies
Highlighted

Re: How to do Forecasting?

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.

Highlighted
Champion
Champion

Re: How to do Forecasting?

See the attachment, Forcasting using What If in QV

Highlighted
Not applicable

Re: How to do Forecasting?

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

Highlighted
Not applicable

Re: How to do Forecasting?

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

Highlighted
Master
Master

Re: How to do Forecasting?

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!”