Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
amilafdo
Creator
Creator

Forecasting in Qlikview

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

amilafdo_0-1607997718823.png

Thanks

Amila

4 Replies
settu_periasamy
Master III
Master III

Hi,

May be try to use the expression like

Above(sum(sales)*1.5)

amilafdo
Creator
Creator
Author

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
Master III
Master III

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

amilafdo
Creator
Creator
Author

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