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

33 Replies
MK_QSL
MVP
MVP

Excellent Marco.. !!

Genius

pnn44794
Partner - Specialist
Partner - Specialist

Hello Marco:

So I'm finally getting around to trying this out with just two values.  One I labeled as Booked and one I labeled as Not Booked.  The first dimension is "Tech Efficiency Work Stream" (there are four possible values, so I'm looking for 4 bars (8 bars if you count the 4 overlapped).  The second dimension is a calculated dimension =ValueLoop(1,3).

It is with the expression part that I believe is where my problem is.  Booked needs to be the following:

=If(ValueLoop(1,3)=2, Num(Sum({$<Phase = {'Booked'}, CIO = {'Allen'}>} RangeMax([Finance Confirmed 2018 Savings], 0)/1000000),'$###0.0'))

While Not Booked is the following:

=If(ValueLoop(1,3)=2, Num(Sum({$<Phase = {'Booked'}, CIO = {'Allen'}>} RangeMax([Estimated Save], 0)/1000000),'$###0.0'))

I believe I need to subtract Booked from Not Booked and then Sum Not Booked again, but I'm not sure how to put this together.  Any ideas?  Thanks in advance.

MarcoWedel

Hi,

can you please post a sample application including some values and your expected result?

thanks

regards

Marco

pnn44794
Partner - Specialist
Partner - Specialist

Hello Marco:

Sorry for the delay. I’m a bit tied up right now on a fire drill for work, but I will get you some sample data, expressions, etc, but I cannot share the app. What I will provide, I believe, will be enough to at least give you an idea of what I’m talking about or so I hope. I’ll try to post something in a couple of days if not sooner. I’m really hoping we or more accurately you, can make this work, but I’ll do whatever I can to assist. I’d love to be able to use the Wedel chart. ☺ Thanks in advance and I appreciate your patience.