Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies