I need some help with creating a forecast chart. I'll keep it simple to aid the solution;
I need to plot Sum(Sales) for each year that I have data, lets say I only have 2012. I then would like to forecast the next 2 years data in the chart, however I want this to be a calculation i.e (last years sales * 0.10) so this means if I kept going the sales would just keep going up and up for every year I add.
It seems the forecast option on charts is just for, how many would you like to forecast forward and not where the calculation for the measure would be.
Any pointers appreciated, I have read most of the qlikview discussions they all seem to be about trending and averages.