Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

varun_krishna
New Contributor III

How to create a Tree Structure Chart ?

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

Tags (2)
5 Replies
aveeeeeee7en
Valued Contributor III

Re: How to create a Tree Structure Chart ?

Hi Varun

Kindly Refer this Post from Sven Uhlig: Tree Visualisation

Hope it will be useful for you.

Regards

Aviral

vikasmahajan
Esteemed Contributor

Re: How to create a Tree Structure Chart ?

You need to create Hierarchy Graph , Please find sample.

Vikas

amit_saini
Honored Contributor III

Re: How to create a Tree Structure Chart ?

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.

IDParentIDIDName
11North America
21Region Europe
31Region Asia
41NA1
51NA2
61NA3
71NA4
82RE1
92RE2
102RE3
112RE4
123RA1
133RA2
143RA3
153RA4

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

Not applicable

Re: How to create a Tree Structure Chart ?

treeview in qlikview.png

this type Of tree structure is possible in qlikview

hope this helps

saurabh_karlewar
New Contributor III

Re: How to create a Tree Structure Chart ?

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