topic Re: Two Bars in a Bar Chart in QlikView

Two Bars in a Bar Chart

Thu, 29 Dec 2011 16:46:56 GMT

Hi all

In my current chart, I have four expressions.

One is total,

Two, three and fourth are Subtotals

I am getting four bars in the graph. I would like to have only two bar, one for total and another bar for subtotal which should be stack.

Is it possible to do that in qv?

Any help would be appreciated

Two Bars in a Bar Chart

orital81 — Thu, 29 Dec 2011 17:08:57 GMT

Hi Saaty, As to my knowledge there is no option to set a chart which is partialy Stacked and partialy seperated. Although, there is a workarround: Option 1: Set the Bar Chart to stack. mark the Total expresstion as invisable and show it's value on chart. This way you will have all subtotals in stacked bar and Total as a number. Option 2: Use a bar chart with lines, show stack bar for Subtotals and line for Total. Hope this was clear and helpful.

Two Bars in a Bar Chart

Thu, 29 Dec 2011 17:33:32 GMT

Thanks for your valuable info Ori.

Option 2 is clear to me, but i didnt get the option 1.

Two Bars in a Bar Chart

johnw — Thu, 29 Dec 2011 19:02:45 GMT

Can you post a sample file? I suspect I can solve it, but I'd need to know exactly what you're after and have some sample data and your expressions and such.

Re: Two Bars in a Bar Chart

Thu, 29 Dec 2011 19:23:24 GMT

Sure. PFA for the sample file.

Thanks a lot!

Re: Two Bars in a Bar Chart

johnw — Thu, 29 Dec 2011 19:32:40 GMT

Attached is one way. There might be a better one, but it works. I created a separate "Count" field with values 'Total' and 'Subtotal'. I added that as a dimension, then changed the expressions to check the "Count" and only return a value if they should be part of that bar.

If this is what you wanted, though, I'm a little confused. The total bar just seems unnecessary, as it is always the same height as the stack of subtotals. It seems like it would be more clear without it.

Re: Two Bars in a Bar Chart

Thu, 29 Dec 2011 20:43:00 GMT

Sure. Thanks for the reply John. Let me look into that and reply back to you!