Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How do i set to load accurately in Hierarcy

Hello,

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

ll.JPG.jpg

3 Replies

Re: How do i set to load accurately in Hierarcy

Hi, first try:

Hierarchy([G/L]....

Not applicable

Re: How do i set to load accurately in Hierarcy

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

Re: How do i set to load accurately in Hierarcy

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!