Bar chart with overlaped bar

[Anonymous]

Hello,

Do you know if it's possible to do this kind of graph ? (with for each month, 2 différents expressions at the same place but with different bar witdh)

Many thanks in advance

[m_woolf]

Could be done by overlaying 2 charts.

[MarcoWedel]

Maybe this helps

https://community.qlik.com/search.jspa?q=bullet+chart

regards

Marco

[Anonymous]

Hello,

I already tried it but I can't change the bar width for the second graph.

[MarcoWedel · Accepted solution]

Hi,

one solution to turn this chart

into this one

could be:

hope this helps

regards

Marco

[sunny_talwar]

Wow!!!!, how is this thing even working? I don't understand what you have done . I feel dumb asking, but can you explain the settings a little more (although you have already showed all of them in the image above)

[MarcoWedel]

Hi Sunny,

I'm glad you like it.

It just struck me that one could make a group of bars appear as one single bar when reducing the space in between to zero.

So I used a second calculated ValueLoop dimension to create clusters of three stacked bars each.

The side bars (1 and 3) here only get a value for the second expression, while the middle bar has values for both the first and second expression. The second expression then is reduced by the first expression value to let the middle stack height equal the side bar height in cases where the first expression is less than the second one.

I'm not convinced this explains it well enough ...?

Marco

[Anonymous]

That's brillant!

[MarcoWedel]

thanks

[sunny_talwar]

It does and it is amazing what you did marcowedel‌. You are amazing