Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

kamalqlik
Valued Contributor

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
Employee
Employee

Re: Hierarchy Load

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

1 Reply
Employee
Employee

Re: Hierarchy Load

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

Community Browser