Forecasting in Qlikview

[amilafdo]

Hi,

I am having a problem with creating a forecast line chart for the next 5 years based on last year sales.

eg: Last year sales is 100 Mn and each year it should be increased by 1.5 (forecast 1st year 100* 1.5, forecast 2nd year 150*1.5). 

the chart should be as below

Thanks

Amila

[settu_periasamy]

Hi,

May be try to use the expression like

Above(sum(sales)*1.5)

[amilafdo]

Hi Settu,

Thanks for your reply, I have tried this and only one year is showing. I need to show for next 5 years.

Thanks

Amila

[settu_periasamy]

Do you have 5 years in your dimension or calendar table? 

[amilafdo]

Hi Settu,

I am having the last 2 years' data and no calendar data or dimensions for the future. I don't want to show the calendar year for the next 5 years and it is enough to show 1-5 in dimension (refer the image I shared). 

Thanks

Amila