Discussion board where members can get started with QlikView.
How can I create a Sales Forecast chart (showing current sales (have data until 2011) and forecast of next year (say 2012) in my QV document. I have YearForecast and Sales as dimensions.
Go to Solution.
Use the time as your dimension, then you need to enter two expressions, one for the forecast, one for the actual sales.
EG dimension = month
expr1 = sum(Sales)
expr2 = sum(YearForecast)
is this what you need?
Thanks Erica. It worked.