Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show or visualize this kind of data?


Hi community,

            I would like to show or visualize the count of infection organisms by departments.There are many departments (over 20) and much more organisms (more than 50). The bubble chart is not a solution, since it requires two numeric expressions. I also tried to use grid chart, but it does not work either. What I want to do is to let users easily find the most organism in different department. I am not sure whether I state my question clear. Thanks

1 Solution

Accepted Solutions
MarcoWedel

Hello Haijun,

I found heatcharts to be very effective in these cases.

To do so, I would create a pivot table with dimensions department and organism name an add the # of organisms as an expression. Then by draging the department dimension to the top of the chart you can create one column per department each. The # of organisms then would be used to color code the background color (expression tab of the charts properties).

The result should look like this:

Heat map example 3.JPG.jpg

By sorting the organism and department dimensions using the # of organisms expression (descending) you can bring the most infectious of your organisms to the top of the table and the most involved departments to the left side.

This also allows for your users to focus on these specific departments and organisms:

Heat map example 4.JPG.jpg

Hope this helps

regards

Marco

View solution in original post

3 Replies
MarcoWedel

Hello Haijun,

I found heatcharts to be very effective in these cases.

To do so, I would create a pivot table with dimensions department and organism name an add the # of organisms as an expression. Then by draging the department dimension to the top of the chart you can create one column per department each. The # of organisms then would be used to color code the background color (expression tab of the charts properties).

The result should look like this:

Heat map example 3.JPG.jpg

By sorting the organism and department dimensions using the # of organisms expression (descending) you can bring the most infectious of your organisms to the top of the table and the most involved departments to the left side.

This also allows for your users to focus on these specific departments and organisms:

Heat map example 4.JPG.jpg

Hope this helps

regards

Marco

MarcoWedel

I forgot the qvw

Here it is ...

Marco

sebastiandperei
Specialist
Specialist

Wow Marco, i was seeing posts to answer, but your idea is very very good!!!

If you let me, i will use it!!