Stacked bar chart question

[#1]

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

[MK_QSL]

can you post your sample apps?

[MK_QSL]

Tick Plot Values inside Segments in Presentation tab.

Make sure Values on Data Points ticked for both expression

[MK_QSL]

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....

[maxgro]

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 %)

[#6]

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

[MK_QSL · Accepted solution]

Like this?@

[#8]

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

[MK_QSL]

Welcome to the Qlik World 🙂