Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Barbell \ Dna chart?

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

This is what I can offer you:

DNA_chart.png

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

View solution in original post

7 Replies
swuehl
MVP
MVP

This is what I can offer you:

DNA_chart.png

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

Not applicable
Author

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
MVP
MVP

awesome swuehl.

Not applicable
Author

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
MVP
MVP

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

DNA_Values.png

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'

Not applicable
Author

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
Contributor III
Contributor III

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