topic Re: Floating Bars on Bar Chart in QlikView

Floating Bars on Bar Chart

brf10043 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

Is there a way to produce a chart like the one below where you could define the where the bottom of the bar starts?

Re: Floating Bars on Bar Chart

sunny_talwar — Thu, 11 Aug 2016 20:11:39 GMT

May be take a look here:

https://www.analyticsvidhya.com/blog/2013/12/create-waterfall-chart-qlikview/

Waterfall Chart Offest Using Dimensions

Re: Floating Bars on Bar Chart

swuehl — Thu, 11 Aug 2016 20:12:15 GMT

There is an bar offset attribute expression available in the expression tab chart properties.

Search for 'water fall chart' in this forum to see more detailed help:

https://community.qlik.com/search.jspa?q=waterfall%20chart&type=document

Re: Floating Bars on Bar Chart

maheshkuttappa — Thu, 11 Aug 2016 20:17:43 GMT

Go to Example apps and Open Data Visualization and check the chart in sheet "Share" , you have an example of water fall chart

Use bar offset to achieve this

Re: Floating Bars on Bar Chart

brf10043 — Thu, 11 Aug 2016 20:29:51 GMT

Thanks everyone, the bar offset attribute was exactly what I needed!

Re: Floating Bars on Bar Chart

brf10043 — Thu, 11 Aug 2016 21:12:51 GMT

Follow up question.

Is it possible to left justify the Dimension labels so they are on the left side of the cluster instead of the center. See image below. I would like for the label to be under the Orange bar.

Re: Floating Bars on Bar Chart

sunny_talwar — Thu, 11 Aug 2016 21:34:42 GMT

As far as I know, this isn't possible. May be try doing something like this:

FieldName & ' ' & Chr(39)

FieldName & ' .'

Re: Floating Bars on Bar Chart

sunny_talwar — Thu, 11 Aug 2016 21:50:49 GMT

See if this idea helps

Re: Floating Bars on Bar Chart

brf10043 — Fri, 12 Aug 2016 13:15:17 GMT

Thanks Sunny! This does exactly what I needed. I did adjust it a little to get the labels to line up with the bars.

Here's the calculated dimension that I used and the resulting chart

Re: Floating Bars on Bar Chart

sunny_talwar — Fri, 12 Aug 2016 13:19:00 GMT

Sure.... Look much better now. Only thing to watch out is that this combination of spaces will need to change based on the number of bars visible at one time. So there might be a need to adjust. But once you have figured how many bars you want to show, you can adjust the label accordingly.

Re: Floating Bars on Bar Chart

swuehl — Fri, 12 Aug 2016 13:25:17 GMT

Another option might be to use a single dimension instead of two in grouped style.

This should resolve your issue with aligning the labels as well, without the need to use white spaces.

Re: Floating Bars on Bar Chart

brf10043 — Fri, 12 Aug 2016 13:41:18 GMT

Thanks guys. I may not have the number of bars. Which means that I would have to adjust the code each time I get refreshed data. That may not be workable. Suggestions?

Stefan, What so you mean by a single dimension? I originally had date as my dimension which centered the Date vale between the three bars (Baseline, In and Out) However, my customer needs to have the In and Out labels on the dimension label line.

Re: Floating Bars on Bar Chart

Anonymous — Fri, 12 Aug 2016 14:16:41 GMT

Thanks guys. I may not have the number of bars. Which means that I would have to adjust the code each time I get refreshed data. That may not be workable. Suggestions?

you may work on some aggr functions on 'Baseline' like count or sum or Rank()

so spaces or characters can be Repeated based on the RANK() !!?

May not be related to this kind but ,can be helpful...!!!

Dual(Country & '-' &Num(sum(Sales), '#,##0') &Repeat(chr(13)&chr(10), rank(Sum(Sales))-6),sum(Sales))

Re: Floating Bars on Bar Chart

swuehl — Fri, 12 Aug 2016 15:05:18 GMT

This is how you can control the labelling with a single dimension (I assumed you were using two dimensions, so my answer was probably confusing).

Pro, no need for white space magic, i.e. if you select some Dim1 or resize your chart, the labelling should still stay correct below the bars.

Con, you can select any number of bars, so you might want to make this chart readonly and let the user select in Dim1 list box.

Re: Floating Bars on Bar Chart

sunny_talwar — Fri, 12 Aug 2016 15:10:35 GMT

This is amazing. But one other issue I see is that all the bars are equiv distant from each other. The grouping effect we had earlier is not there. Is that something which can be possible be done Stefan?

Re: Floating Bars on Bar Chart

swuehl — Fri, 12 Aug 2016 18:29:31 GMT

Hm, I think there is no easy way to do this. You can create a fourth dummy Dim2 value with basically a zero bar, but then the gap would be quite large.

But IMHO, I like it this way even better (and it's closer to the image posted in the OP), because then IN and OUT would nicely build a bridge between the year bars.