Announcements
cancel
Showing results 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.

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

Cheers,

Niko

1 Solution

Accepted Solutions
MVP

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

7 Replies
MVP

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

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

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

MVP

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'

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

Contributor III

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

Community Browser