topic Re: Stacked charts - multiple stacks in QlikView

Stacked charts - multiple stacks

Tue, 25 Mar 2014 13:55:52 GMT

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.

Re: Stacked charts - multiple stacks

srchilukoori — Tue, 25 Mar 2014 14:04:08 GMT

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.

Re: Stacked charts - multiple stacks

Wed, 26 Mar 2014 13:27:42 GMT

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.

Re: Stacked charts - multiple stacks

srchilukoori — Wed, 26 Mar 2014 14:09:36 GMT

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:

Re: Stacked charts - multiple stacks

Wed, 26 Mar 2014 17:35:48 GMT

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.