topic Qlik Sense and Diverging Bar Chart (or bikini chart) in App Development

Qlik Sense and Diverging Bar Chart (or bikini chart)

Sat, 16 Nov 2024 10:36:50 GMT

Hello,

Is it possible to create diverging bar chart, or more funny name for it, a bikini chart?

Something like the below one is, what is made with Tableau.

If this is not possible out of the box, how can I flip the bar chart around without using - in front of the expression?

I want to display the expression value also on the bar, so the - mark isn't suitable for the job.

So in Qlik Sense we can have to bar charts like this:

But I would like to see them like this (flipped with paint):

Any help is always help!

Cheers,

Niko

Re: Qlik Sense and Diverging Bar Chart (or bikini chart)

Gysbert_Wassenaar — Fri, 27 May 2016 13:48:00 GMT

Try a butterfly chart:

Or in other words. A bar chart with two expressions and stacked bars in a horizontal layout.

The measure for the negative bars is -Count(Sales) in the example. The formatting of the measure is set to number with a custom formatting pattern #,##0.00;#,##0.00 so that negative numbers are displayed without a leading '-' sign.

Re: Qlik Sense and Diverging Bar Chart (or bikini chart)

Fri, 27 May 2016 13:57:36 GMT

Well I feel stupid right now, of course you can do it with the stacked option !

Thank you very much, this was a really good help for my friday brains. Thanks!

The only question remains, do i need to put the custom formatting inside the expression itself with the num() expression?

Cheers,

Niko

Re: Qlik Sense and Diverging Bar Chart (or bikini chart)

Fri, 27 May 2016 13:58:45 GMT

Edit.

Never mind, got that done already as well!

Thank you again! Superb!

Cheers,

Niko

Re: Qlik Sense and Diverging Bar Chart (or bikini chart)

dksundaram_te — Fri, 04 Jul 2025 14:07:14 GMT

Hi Niko,

Can you please explain step by step on how did you achieved this graph?

Thanks and Regards,

Kalyan