How to create a Tree Structure Chart ?

[Anonymous]

Hi everyone

Please find the image attached, and I would like to create a chart in qv exactly the same way as shown in the image. Is this possible to do in qv?

Thanks,

Varun Krishna. P

[aveeeeeee7en]

Hi Varun

Kindly Refer this Post from Sven Uhlig: Tree Visualisation

Hope it will be useful for you.

Regards

Aviral

[vikasmahajan]

You need to create Hierarchy Graph , Please find sample.

Vikas

[amit_saini]

Hi Varun,

You have to create Hierarchy , Please see below:

Suppose you are having 3 regions North America (Inside this you have plants like NA1, NA2....), Region Europe (RE1,RE2...) and Region Asia (RA1,RA2,.....). You can create a Hierarchy here as you can see below the way I did.

ID	ParentID	IDName
1	1	North America
2	1	Region Europe
3	1	Region Asia
4	1	NA1
5	1	NA2
6	1	NA3
7	1	NA4
8	2	RE1
9	2	RE2
10	2	RE3
11	2	RE4
12	3	RA1
13	3	RA2
14	3	RA3
15	3	RA4

Now call this sheet in to the Qlikview application , in a list box and Enable the option (Show as a tree view)

Thanks,

AMIT SAINI

[#5]

this type Of tree structure is possible in qlikview

hope this helps

[saurabh_karlewar]

It's very simple to create the tree structure using hierarchy. 

You can refer to the below sample code which I've used in my app

Employee:

LOAD [Employee Number] as EmployeeID,

     [Full Name] as Name,

     [Primary E-mail],

     Manager as ManagerName,

     [Employee Number (Manager)] as ManagerID,

     Tragets

FROM

User_info.xlsx

(ooxml, embedded labels, table is Sheet1);

Hier:

Hierarchy (EmployeeID, ManagerID, Name, ManagerName,Name, ReportsPath)

LOAD EmployeeID, ManagerID, Name,Tragets, recno() as recno

RESIDENT Employee

;

After loading the data, create the list box using ReportsPath and check "Show as TreeView" in properties

You can also visit following link

http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/11/unbalanced-n-level-hierarchies