0 Replies Latest reply: Oct 4, 2012 5:35 AM by James Rowley RSS

    Chart forecasting on previous values

      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