topic Re: TreeMap usage and application in QlikView

TreeMap usage and application

paulyeo11 — Mon, 07 Sep 2015 01:54:58 GMT

HI All

After I play with treemap I notice that it is not as useful as I though , because it auto filter unlike bar chart it does not . May be some one can share with me how to fully use of this treemap ?

Paul

‌

Re: TreeMap usage and application

Fri, 16 Oct 2015 12:01:38 GMT

Hi Paul,

i got a use of the treemap, it's for a helpdesk ticket analisys.

Each ticket opened by the helpdesk have a subject on severla level, examples

Software / Microsoft Office / excel / macro / problem descriptions
Hardware / computers / hard drives / problem deswcription
Hardware / printer / tray / problem description

here we have hundred or thousands of open tickets, and the target is to know wich topics are mostly opened then you need to do folowing :

put in dimensions the subject, with only 1 level per dimension, per example dimension 1 will be the 1st level subject (Software OR Hardware), and the second dimesion the next level , etc (the more dimensions you put, the more you can later dig)
in the measure put what you like to compare, it can bee the average open time , number of calls for the topics

This Treemap is useful to dig into the information, here the larger the surface will be , the more attention it need to get, and you can select one subject a time to get more granularity So, if you want more precise information on the subject you have to enlarge an area that's why, when you select an area it zoom on this only area.

I hope this will help you

Re: TreeMap usage and application

paulyeo11 — Sat, 17 Oct 2015 11:18:53 GMT

Hi Sir

Thank you very much for your sharing , it is possible to explain with the QS Application. As I am a visiual persons.

Paul

Re: TreeMap usage and application

Mon, 19 Oct 2015 07:40:41 GMT

Hello Paul,

There is a good example in the example app "consumer goods sales", under the "Sales rep perforamce"

if you play with it , you will see that even with this basic example , it become easy to see a trend, and the surface is a nice tool to see what is important to look at.

Robert