topic Re: Stacking Two Expressions in Bar Chart in QlikView

Stacking Two Expressions in Bar Chart

Wed, 15 Oct 2014 18:04:42 GMT

Hi,

I have a bar chart with three expressions and one dimension. I want to stack two expressions in one bar (the first expression is basically full year budget, and the second one is YTD budget). Anyway, I don't want to use "Stacked" as a subtype in the Style cause it will stack the three expressions in the time I need to stack only two. So how can I achieve that?

Your help is highly appreciated!

Thanks!

Re: Stacking Two Expressions in Bar Chart

Thu, 16 Oct 2014 15:30:32 GMT

Any help on this post?

Thanks!

Re: Stacking Two Expressions in Bar Chart

tiagopost — Thu, 16 Oct 2014 16:03:32 GMT

Did you try to show full year budget at YTD budget label?

Try to to rename the Label YTD budget to ='YTD budget - Full Year ( '&sum(budget) &')'

Re: Stacking Two Expressions in Bar Chart

Thu, 16 Oct 2014 18:00:57 GMT

Well, I have both of them in separate expressions (YTD, Full Year). So what I'm trying is to combine both of these two axis into one as a stacked bar.