topic How to create a Tree Structure Chart ? in QlikView

How to create a Tree Structure Chart ?

Anonymous — Mon, 17 Feb 2014 01:26:51 GMT

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

Re: How to create a Tree Structure Chart ?

aveeeeeee7en — Mon, 17 Feb 2014 02:19:17 GMT

Hi Varun

Kindly Refer this Post from Sven Uhlig: Tree Visualisation

Hope it will be useful for you.

Regards

Aviral

Re: How to create a Tree Structure Chart ?

vikasmahajan — Mon, 17 Feb 2014 03:48:19 GMT

You need to create Hierarchy Graph , Please find sample.

Vikas

Re: How to create a Tree Structure Chart ?

amit_saini — Mon, 17 Feb 2014 05:02:39 GMT

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

Re: How to create a Tree Structure Chart ?

Mon, 17 Feb 2014 05:28:15 GMT

this type Of tree structure is possible in qlikview

hope this helps

Re: How to create a Tree Structure Chart ?

saurabh_karlewar — Mon, 17 Feb 2014 06:08:10 GMT

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