topic Re: group bars in a waterfall chart in QlikView

group bars in a waterfall chart

Mon, 14 Sep 2015 19:47:12 GMT

I need to create a table that looks like this where the blue, red, and gray bars are predefined values. The orange, yellow, and green bars are also pre-defined values (left) but I also need a duplicate bar next to them that change based on user entries (right). I need the three middle bars to group under one label. I am thinking this may be accomplished with multiple dimensions but I'm not quite sure how to set it up. Any suggestions would be appreciated! I don't want to group the expressions because I need them all visible at the same time.

Re: group bars in a waterfall chart

Oleg_Troyansky — Mon, 14 Sep 2015 20:05:41 GMT

It looks like the classic Groupped Par Chart:

you need two dimensions - one that supplies the "Label", and the other one that differentiates Left/Right.
The first bar and the last two bars would only have one entry for the secondary dimension.
Use calculated colors to paint the chart accordingly
Use the same "bar offset" for the two bars that need to begin at the same point.
Play with the "Bar Distance" setting to reach the desired presentation.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: group bars in a waterfall chart

dgreenberg — Mon, 14 Sep 2015 22:39:06 GMT

To me it looks like Tetris

Re: group bars in a waterfall chart

Thu, 17 Sep 2015 16:45:33 GMT

Oleg,

I get that but I'm not sure how to load the two dimensions. right now I'm getting the equivalent of 6 side by side waterfalls squished into the table. Do I just need one expression that says IF left (left bar) then this value, else that value (for right bar)?

Re: group bars in a waterfall chart

Oleg_Troyansky — Thu, 17 Sep 2015 16:49:29 GMT

Yes, exactly - that's how it should work.

Re: group bars in a waterfall chart

Thu, 17 Sep 2015 16:51:34 GMT

Ok thank you. I'll work on that.

Re: group bars in a waterfall chart

Oleg_Troyansky — Thu, 17 Sep 2015 17:02:19 GMT

Excellent! Please mark the answers as helpful/correct and close the thread 🙂

Re: group bars in a waterfall chart

Thu, 17 Sep 2015 17:33:48 GMT

I will be happy to as soon as I get it correct

One more question... how do I eliminate the gap between the bars that only use one of the dimensions? I tried suppressing when value is null but it's not responding to that. Also, it won't show grid lines even though I have it set to show them. thoughts on that?

Re: group bars in a waterfall chart

Oleg_Troyansky — Thu, 17 Sep 2015 18:07:57 GMT

I doubt if the gap can be removed, unfortunately.
Grid lines - check the grid line color. I suspect it might be white on a white background.
In addition to Grid lines, I'd add Axis lines - set their Width to 1 and Color to gray.
Also, as a side comment - consider moving away from shadows and gradient colors. They are not in fashion anymore 🙂

Re: group bars in a waterfall chart

Fri, 18 Sep 2015 13:09:12 GMT

I have managed to get the chart as I want it. Thank you Oleg for your help!!