topic Hierarchy in QlikView

Hierarchy

brindlogcool — Sun, 24 Jun 2012 13:54:22 GMT

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

Re: Hierarchy

swuehl — Sun, 24 Jun 2012 16:43:41 GMT

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)?

Re: Hierarchy

brindlogcool — Sun, 24 Jun 2012 20:06:57 GMT

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

Re: Hierarchy

swuehl — Sun, 24 Jun 2012 23:29:47 GMT

Could you post some sample lines of your input data?