Discussion Board for collaboration related to QlikView App Development.
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
May be try to use the expression like
Thanks for your reply, I have tried this and only one year is showing. I need to show for next 5 years.
Do you have 5 years in your dimension or calendar table?
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).