Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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