topic Re: Stacked bar chart question in QlikView

Stacked bar chart question

Thu, 30 Jan 2014 13:31:53 GMT

Hi,

I want to display a total budget vs spend to date, and have a bar chart stacked to show how much has been spent vs the total budget.

Seems like this should be a stacked bar chart and it looks like what I was expecting, except it adds the two values, so literally stacks the two on top of each other, rather than overlay the spend on top of the total budget.

Thanks

Simon

Re: Stacked bar chart question

MK_QSL — Thu, 30 Jan 2014 13:37:51 GMT

can you post your sample apps?

Re: Stacked bar chart question

MK_QSL — Thu, 30 Jan 2014 13:41:25 GMT

Tick Plot Values inside Segments in Presentation tab.

Make sure Values on Data Points ticked for both expression

Re: Stacked bar chart question

MK_QSL — Thu, 30 Jan 2014 13:44:05 GMT

Another Option is VALUES on Data Points untick for both expressions...

Create another expression

'Budget :'&SUM(Budget) &CHR(10)&

'Spend :'&SUM(Spend)

Untick Bar and Tick Values on Data Points....

Re: Stacked bar chart question

maxgro — Thu, 30 Jan 2014 13:57:54 GMT

if you choose stacked Qlikview stacks the two on top of each other

IMHO I tkink is better to use a combo chart (image) or a chart with only delta (absolute or %)

Re: Stacked bar chart question

Thu, 30 Jan 2014 13:59:44 GMT

Thanks for the feedback.

Not quite what I'm looking for though. If, for example, the total budget is 100 and the total spend was 50, I wanted the graph to show a bar of 100, that was half full.

I've attached an illustration of what I'm after. Test1 is what I want to see should Total budget be 100 and the spend 50. I've had to fudge it so that they are both 50. I want all the bars to be 100 high, but it keeps stacking them on top of each other. So a 100, 100 combo would be completely red, bot 100 blue and 100 red.

Thanks

Simon

Re: Stacked bar chart question

MK_QSL — Thu, 30 Jan 2014 14:53:57 GMT

Like this?@

Re: Stacked bar chart question

Thu, 30 Jan 2014 14:56:31 GMT

Fantastic, thanks for your help, that's exactly what I was after!

Re: Stacked bar chart question

MK_QSL — Thu, 30 Jan 2014 15:16:11 GMT

Welcome to the Qlik World 🙂