Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
Creator III
Creator III

Hierarchy

Hi,

How to handle the Hierarchy if there is a null while splitting in to columns. For ex consider we have a path \Level1\Level2\Level5  this the generated path fpr the Hierarchy the Level 5 is reporting to directly to Level 2 skipping Level 3 and Level 4. But while splitting this path into columns i need to leave null or blank for Level 3 and Level 4. Otherwise in the pivot table it would be a problem is there any way to get this done in Qlikview

I would like to get as below

                                       C1         C2             C3            C4              C5

Level1\level2\level5           Level1    Level2                                           Level5

3 Replies
swuehl
MVP
MVP

If you want to emphasize that Level5 is directly reporting to Level2, I would probably build the hierarchy like this, i.e. linking Level5 directly to Level2.

I assume that you want to show something else at the same time, like a internal classification (e.g. payment levels, company structure (CEO, Director, Group Leader, Senior, Junior) and a Junior may report directly to a Director).

Maybe consider using two different views (reporting hierarchy vs. classification)?

brindlogcool
Creator III
Creator III
Author

I want to show the Tree in the Pivot table consider you have City,Region,State aligned to sales person. Sometimes the sales person in the city will be directly reporting to state level.

I want to classify like this

As per tree view it will look like this

Natl\State\Region\City

Nat\Region\City

and the above two statements is correct but in pivot table i want to show as column

NATIONAL   STATE   REGION CITY

NATIONAL                REGION  CITY

Atleast i need a way to split the path in to columns Correctly all the regions should come inregion column ra

NAT         REGION        City  

I was trying to loop through records and place on the specific coulmn 

I am trying to check the field value , it is showing 0 records if i could get teh field value i can place it through subfieild

For i=1 to NoOfRows('TREE1')

Load

FieldValue('PATH',0) as C1,

RowNo() as Rno

Resident TREE1 WHERE RowNo()=$(i);

Next i

swuehl
MVP
MVP

Could you post some sample lines of your input data?