I have a requirement where I show up the Actual Cost and the Forecast costs in one graph.
The graph should show the accumulated costs of Actual and the Forecast and the Forecast should start where the Actual ends.
But What i could not get is to remove the projection line for the actual cost.
When i use Accumulation option in the chart the actual line goes beyond its Actual Year as a standard projection.
But I do not want the graph to show up the line beyond its Year of Cost. If the Actual amounts are till 2002 the line should stop at 2002 with accumulation.
And the Forecast should start at where the accumulated Actual Cost stops.
I have attached the QVW what i could get. I appreciate any suggestion on this.
The solution seems to be a clever one and it would work if I have only 2 cost types.
But in my requirement I would have more than one forecast and I would also have Planned and other type of lines.
Please find the attached where I have added Planned details into the QVW.
Now I would want the Actual to be accumulated and only till its specific year values and then the Forecast and Planned to show up right from where the Actual stops.
May be its my mistake for not providing enough information. I apologise for that.
My graph would be so dynamic that the forecasts are created on the go and these new forecasts are pulled into the graph and reloaded.
Moreover, the user might create more than 10 or even 20 forecasts.
The forecasts or planned are not something we would know before. and In forecasts I would have Forecast 1 or Forecast 2 or ....Forecast 15.
Thanks for the quick turn around by my requirement quite more complex that we got so far.
If I could somehow get to know how i can get Aggregated amounts into the graph then I could add this amount to the Forecasts or other line amounts to start from where Acutal ends. This is just my assumption. There might better ways of doing it.
So I would have Actuals for a specific set of years and the users would make forecast for the next few years and this could different forecasts not just one forecast.
In Qlikview if you set the full accumulation and if you take actual , forecast and planned are a separate expressions, Actual graph will be continued to the forecast years.
that's the reason I'm just using the Cost type flag. and keeping the Actual while calculating both forecast and Planned.
And it will work even if you have forecast for multiple years.
if you mean that you have multiple types of forecast and multiple types of actuals also, you may have to create new expressions.
I'm littile bit confused with the above description. You may attach possibily of other forecast and planned, will try to sort.
