topic Re: creating a hierarchy structure in QlikView

creating a hierarchy structure

saurabh_karlewar — Thu, 13 Feb 2014 12:31:59 GMT

Hi,

I am trying to create a hierarchy structure. My sample data is shown in the below table

I tried creating a hierarchy using pivot table, but the structure created is incorrect as the manager name appears in user column.

The expected structure I am looking for is as below with the +/- symbols

Can someone help me with this?

datanibbler — Thu, 13 Feb 2014 12:41:52 GMT

Hi Saurabh,

I cannot quite think it out, but I think you need a LOOP as you will have to go throu all the records several times:

- look for a name (that is not present in the "User" column, so this person does not have a higher manager)

=> Take that name and read all the records where it is in the "Manager" column

=> Read the name(s) in the "User" column

=> Look for this name in the "Manager" column

(LOOP)

HTH

Best regards,

DataNibbler

giakoum — Thu, 13 Feb 2014 12:43:15 GMT

why not use a hierarchy? check it out in the manual or :

hic — Sun, 16 Feb 2014 17:33:04 GMT

You should definitely use a Hierarchy prefix:

Hierarchy (UserID, ManagerID, UserName, ManagerName, UserName, Path, '/', Depth)

Load

User as UserID,

Manager as ManagerID,

User as UserName

Inline

[User,Manager

Satish,Murali

Murali,Jayesh

Abdul,Jayesh

Jayesh,Venkat

Aarti,Venkat

Venkat,];

Then you can use the created fields both for a pivot table and a tree-view list box. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/11/unbalanced-n-level-hierarchies

HIC