Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kamalqlik
Partner - Specialist
Partner - Specialist

Hierarchy Load

Hi Friend,

I want to implement Hierarchy for the Fingrp table.

ParCode is the parent Code.

Grpcode will be the child node.

I want the hierarchy upto level 3 for this.

Regards

Kamal

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Just use

Hierarchy (GRPCODE, PARCODE, GRPNAME, ParentName, GRPNAME, Path, '/', Depth)

LOAD * from FINGRP.qvd (qvd);

It will load all 5 levels, but by selecting 1,2,3 in the Depth field, you will see just the first three levels.

HIC

View solution in original post

1 Reply
hic
Former Employee
Former Employee

Just use

Hierarchy (GRPCODE, PARCODE, GRPNAME, ParentName, GRPNAME, Path, '/', Depth)

LOAD * from FINGRP.qvd (qvd);

It will load all 5 levels, but by selecting 1,2,3 in the Depth field, you will see just the first three levels.

HIC