Qlik Community

QlikView Documents

Documents for QlikView related information.

Human Body Parts Graph

Not applicable

Human Body Parts Graph

A picture is worth a thousand words, and this is even more true in BI. With this in mind, it came to me this solution for representing accidents in a plant in a QV document, as one of the most important issues for reducing the accidents is the part of the body that has been injured (the size of the bubble shows the number of accidents in that part of the body):

Body Graph.png

This is a just a dispersion graph with an image on its background. It has one dimension (Body Part), and three expressions: One for the X axis, another for the Y axis, and another one for the bubble size. For the first two expressions, we need to map each body part we handle in our data with a position in the graph. For this, I created an excel file for mapping (see attached). The third expression (size) is just the sum of all the accidents.

Once we have the mapping loaded, just have to fix the graphs max and min axis, so that it won't be resized after a selection. In my example, X is fixed to 8.3 and Y to 19.4.

Change the background with a body image (attached), and its done.

Please note that this graph is almost worthless if we don't combine it with other dimension data. This is my document's final result:

Final.png

I attach the image, the mapping excel, and the qvd:

Attachments
Comments

Nice work.

Not applicable

Ouch!! Really like the layout and look of this document, if not a bit morbid

Not applicable

Well Done

christophebrault
Valued Contributor

Hi,

Very nice work !

pgrenier
Contributor III

Very nice work! :-)

Not applicable

Nice Work

hariharasudan_p
New Contributor III

Wonderful piece of work.

Neatly written script and well structured.

m2r4miller
New Contributor III

Very nice!

thornofcrowns
Valued Contributor II

Nicely done!

julian_rodrigue
Valued Contributor

It looks great, good job!

Version history
Revision #:
1 of 1
Last update:
‎08-22-2013 04:15 AM
Updated by: