Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!

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
heap_qlik
Creator
Creator

Nice!!! Can I get background image?

0 Likes
Not applicable

Excellent dashboard for looking at (preventing) workplace accidents.  I will definitely add this to my list of projects.  Thankyou.

MK_QSL
MVP
MVP

Excellent work done

0 Likes
Not applicable

Very good example and nice design Iosu! Have you considered adding (if you have the data) the time to recover as another KPI and maybe a map of where (in the plant) happened the incident? Again, great work!

----

Genial ejemplo y buen diseño Iosu! ¿Has pensado en añadir (si tienes los datos) el tiempo de baja por lesión y/o un mapa de dónde han sido los incidentes? Gran trabajo, sigue así!

Not applicable

Great example, Iosu! and thank you for sharing.

Very good idea using the body graph to show the body parts much better than in a list or chart axis. This is more "Natural" and easier to consume.

0 Likes
Not applicable

This is awesome!!! Thanks for sharing!

0 Likes
Not applicable

Nice work

0 Likes
falgunip
Contributor III
Contributor III

Very nice work !

and thanks for sharing

0 Likes
junasharma
Creator
Creator

Hi Isou,

How did you import the Human Body Image to the visualization?

0 Likes
Viktor
Contributor II
Contributor II
This is a great app
0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2013-08-22 04:15 AM
Updated by: