You can achieve it with data well structured.
Try to have a file like this
Create a field metric with only 2 values, create a field forecast where is null for metric = Budget
Then create a bar stack bar chart with Metric as dimension and 2 expressions Sum(Value) , Sum(Forecast)
Mois Metric Value Forecast 1 Budget 100 0 1 Actual 70 20 2 Budget 200 0 2 Actual 200
Basically, your problem is that you are trying to combine a Group Chart and a Stacked Chart, and it doesn't work together. So, you need to trick QlikView into treating it as a Stacked chart - 2 Dimensions, 1 Expression.
To achieve your goal, you need to create a dummy table with 2 fields, associated with each other:
In the expression, you'll need to validate the value of Dimension2 and use the appropriate formula.
Now, the first Dimension will cause creating of 2 separate bars, and the 2 values of the Second Dimension will make he bars stacked.
Thanks for the quick responses. You got me thinking about the problem from a different angle. Here is how I solved the problem:
I reformat the data:
Then I created a chart using Council and Type as dimensions. I used three expressions, sum(Budget), only(Actual), only(Forecast). Apparently the "only" function filters just the values I wanted. Resulting in the chart below: