Stacked charts - multiple stacks

[#1]

I am new to QlikView and I am trying to create a stacked chart which contains two stacks - the first is a stack of 2 values from a table (actual cost and out-turn cost) and compares this to a second stack with a single value (full year budget cost) from the same table.

This seems a simple concept but I cannot find anything within the chart Properties to accommodate this.  I suspect my inability to produce this view is down to my inexperience of using QlikView.

Any help would be appreciated.

Thanks.

[srchilukoori]

Please attach a screenshot or a sample app.

The bar chart gives an option to either group the bars or stack them and not a combination of both. You may want to explore other options using Combo chart.

[#3]

Hi

Thanks for the reply.  I've attached a screenshot of how this would look in excel.

Currently, the values I would like to use are stored in the same table in QlikView.

Thanks.

[srchilukoori]

You can try using the combo chart with budget as a line plot and the Actual and Out_turn as the stacked bar charts.

Or the Actual YTD as a line plot while budget and out-turn are stacked as below:

[#5 · Accepted solution]

Hi, thanks for the suggestion.  I have now managed to resolve this myself via the following method.

1) I edited the load script as follows -

load * inline [

Type

Budget Full Year

Actual + Out-turn

];

2) Under the definition for each expression I entered the following

Actual Cost : =if(Type='Actual + Out-turn',sum([Actual Cost]))

Outturn : =if(Type='Actual + Out-turn',(sum([Outturn])-sum([Actual Cost])))

Budget Cost :  =if(Type='Budget Full Year',sum ([Budget Cost]))

3) Set Accumulation on each expression to No Accumulation

This gives me what I need.

Thanks.