Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

5 Replies
aveeeeeee7en
Specialist III
Specialist III

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
amit_saini
Master III
Master III

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
Author

treeview in qlikview.png

this type Of tree structure is possible in qlikview

hope this helps

saurabh_karlewar
Contributor III
Contributor III

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