Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bar chart with overlaped bar

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)

overlaped bar.png

Many thanks in advance

1 Solution

Accepted Solutions
MarcoWedel

Hi,

one solution to turn this chart

QlikCommunity_Thread_284820_Pic1.JPG

into this one

QlikCommunity_Thread_284820_Pic2.JPG

could be:

QlikCommunity_Thread_284820_Pic3.JPG

QlikCommunity_Thread_284820_Pic4.JPG

QlikCommunity_Thread_284820_Pic5.JPG

QlikCommunity_Thread_284820_Pic6.JPG

hope this helps

regards

Marco

View solution in original post

33 Replies
m_woolf
Master II
Master II

Could be done by overlaying 2 charts.

MarcoWedel

Anonymous
Not applicable
Author

Hello,

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

MarcoWedel

Hi,

one solution to turn this chart

QlikCommunity_Thread_284820_Pic1.JPG

into this one

QlikCommunity_Thread_284820_Pic2.JPG

could be:

QlikCommunity_Thread_284820_Pic3.JPG

QlikCommunity_Thread_284820_Pic4.JPG

QlikCommunity_Thread_284820_Pic5.JPG

QlikCommunity_Thread_284820_Pic6.JPG

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
Not applicable
Author

That's brillant!

MarcoWedel

thanks

sunny_talwar

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