topic Re: How to show or visualize this kind of data? in QlikView

How to show or visualize this kind of data?

Sun, 02 Mar 2014 15:54:12 GMT

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

Re: How to show or visualize this kind of data?

MarcoWedel — Mon, 03 Mar 2014 00:40:22 GMT

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:

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:

Hope this helps

regards

Marco

Re: Re: How to show or visualize this kind of data?

MarcoWedel — Mon, 03 Mar 2014 00:45:24 GMT

I forgot the qvw

Here it is ...

Marco

Re: How to show or visualize this kind of data?

sebastiandperei — Mon, 03 Mar 2014 04:42:23 GMT

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

If you let me, i will use it!!