Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

TreeMap usage and application

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

3 Replies
Not applicable

Re: TreeMap usage and application

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

paulyeo11
Valued Contributor II

Re: TreeMap usage and application

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

PT TDS Technology | Ruko Celebration Boulevard, Blok AA9 No. 63, Grand Wisata | Tambun-Bekasi-West Java 17510 | Mobile: +62 858 8352 1036 | Phone & Fax: +62 21 82615966 | Website: www.tdstech.com

Not applicable

Re: TreeMap usage and application

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

Community Browser