Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need to create Hierarchy

Hi All,

I have a data set as shown below.

I want to make a tree structure by using Hierarchy  function in QV

nameIDposition
郑炜809956salesman
杨建栋700010DSM
杨莉700020DSM
于波700030DSM
张鹏700040DSM
杭益智700050DSM
邬津萍700060DSM
张荣700070DSM
朱刚700080DSM
皇甫少陵700090DSM
汪泯700100DSM
赵利700110RSM
刘毅浜700120RSM
林奕700130RSM
吴团正700140SRSM
刘军700150SRSM
林伟彬700160RSM
张建军809864salesman

In the above table, hierarchy is defined in the form of position :

Now my requirement is I want to create hierarchy like

LEVEL1 SRSM

LEVEL2 RSM

LEVEL3 DSM

LEVEL4 SALESMAN

For Example:

SRSM

          RSM

                  DSM

                         SALESMAN

SRSM should have all the IDs that SRSM have like in the above example it is 700140 , 700150

then under SRSM there should be all the ID's and NAME which are reporting to SRSM i.e. RSM (ID's and Name) like 700160 ,700130 and so on.

Please help me

Very urgent

2 Replies
khadeer
Specialist
Specialist

Hi,

Check the attached document.

Check the below link also.

http://community.qlik.com/message/252799#252799

Not applicable
Author

In my case its not working .