Floating Bars on Bar Chart

[brf10043]

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?  

[sunny_talwar]

May be take a look here:

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

Waterfall Chart Offest Using Dimensions

[swuehl]

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

[maheshkuttappa]

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

[brf10043]

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

[brf10043]

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.

[sunny_talwar]

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

FieldName & '       ' & Chr(39)

or

FieldName & '       .'

[sunny_talwar]

See if this idea helps

[brf10043]

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

[sunny_talwar]

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.