Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)?
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
Could you post some sample lines of your input data?