Barbell \ Dna chart?

[#1]

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

[swuehl · Accepted solution]

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

[#3]

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

[Chanty4u]

awesome swuehl.

[#5]

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

[swuehl]

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'

[#7]

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

[snancyiv]

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