How do i set to load accurately in Hierarcy

[#1]

Hello,

How do we set Qlik to load data in hierarchy. I have been getting error trying to load in that order

[rubenmarin]

Hi, first try:

Hierarchy([G/L]....

[#3]

Still having problem mapping the fields i want in hierarcy together the form. The Hierarcy Parameter form is not very descriptive

[rubenmarin]

Hi, I don't understand what kind of hierarchy you are searching, the hierarchy makes relations between a node ID and his parent, ie:

orig:

LOAD * INLINE [

    account,parent,name

    100001,100,account 100001

    100,1,group 100

    1,,group 1

    200002,200, account 200002

    200,2,group 200

    2,,group 2

];

Hierarchy (account, parent, name, 'Parent name', name, 'Path', '#', 'Level')

LOAD account, parent, name Resident orig;

DROP table orig;

Try the script and check the results...

Parameter 1 is the id of the record

Parameter 2 is the parent

Parameter 3 is the name of the node

Parameters 4,6 and 8 are strings Qv uses to name the fields.

Parameter 5 is the field QV uses to build the path.

Parameter 7 is the character QV uses as separator when creating paths

Hope this helps!