Chart forecasting on previous values

Thu, 04 Oct 2012 09:35:43 GMT

Hi,

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.

Thanks

James

topic Chart forecasting on previous values in QlikView

Chart forecasting on previous values