Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

mickaelems
New Contributor II

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

Re: Bar chart with overlaped bar

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

33 Replies
mwoolf
Honored Contributor II

Re: Bar chart with overlaped bar

Could be done by overlaying 2 charts.

Re: Bar chart with overlaped bar

mickaelems
New Contributor II

Re: Bar chart with overlaped bar

Hello,

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

Re: Bar chart with overlaped bar

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

Re: Bar chart with overlaped bar

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)

Re: Bar chart with overlaped bar

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

atkinsow
Valued Contributor II

Re: Bar chart with overlaped bar

That's brillant!

Re: Bar chart with overlaped bar

thanks

Re: Bar chart with overlaped bar

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

Community Browser