topic Barbell \ Dna chart? in QlikView

Barbell \ Dna chart?

Mon, 07 Mar 2016 11:47:13 GMT

Hello.

I have been using quite a lot of Tableau in my work and now I am using QlikView (again).

I came across a chart that I need, and I would like to know from you guys if it is possible to do in QV.

I am talking about the barbell \ dna chart.

Like this one: http://3.bp.blogspot.com/-SeGv7M5WgL4/VYwYhS7-DfI/AAAAAAAAhM4/Znn3qPMZNko/s1600/DNA%2BCharts.png

If there is any help you can provide, it would be much appreciated.

Cheers,

Niko

Re: Barbell \ Dna chart?

swuehl — Tue, 08 Mar 2016 21:00:51 GMT

This is what I can offer you:

It's a horizontal combo chart with dimension State and two expressions for Average and Median and a box plot to draw the small connecting line.

Average

=Avg(Value)

Median

=Median(Value)

Box Plot Top

=(Avg(Value)+Median(Value))/2

Box Plot Bottom

=(Avg(Value)+Median(Value))/2

Box Plot Middle (no expression)

Upper Whisker

=Avg(Value)

Lower Whisker

=Median(Value)

Hope this helps,

Stefan

Re: Barbell \ Dna chart?

Wed, 09 Mar 2016 06:38:26 GMT

Hi swuehl!

I will take a look on that solution, but it really seems that it is possible to do with QlikView too. Amazing!

I really thought that it could not be done with QV, but it is really nice to see that it can be done also with QV.

Really nice, thank you once again!

Cheers,

Niko

Re: Barbell \ Dna chart?

Chanty4u — Wed, 09 Mar 2016 06:47:22 GMT

awesome swuehl.

Re: Barbell \ Dna chart?

Wed, 09 Mar 2016 07:13:11 GMT

I would like to add a question here: Is it possible to add number values inside the dots?

I managed to do this barbell chart with your guide, thank you very much!

Cheers,

Niko

Re: Barbell \ Dna chart?

swuehl — Wed, 09 Mar 2016 23:10:22 GMT

I don't think it's possible to add values inside the dots, but nearby:

On expression tab, change the expressions for median and avg to

=Dual( Chr(160) & chr(13) & Median(Value), Median(Value))

=Dual( Chr(160) & chr(13) & Round(Avg(Value)), Avg(Value))

and enable for both expressions display option 'values on data points'

Re: Barbell \ Dna chart?

Thu, 10 Mar 2016 06:37:53 GMT

Well that's a bummer, that you can not put them inside the dots.

Have to live with you have, right ?

Thank you again!

Cheers,

Niko

Re: Barbell \ Dna chart?

snancyiv — Fri, 27 Jan 2023 12:32:06 GMT

Hi! This is an old post but is this possible in Qlik Sense?