topic Re: Help with Hierarchy in QlikView

Help with Hierarchy

hopkinsc — Fri, 20 Jun 2014 15:49:44 GMT

Hi all,

I'm trying to get a bill of materials Hierarchy working, Can anyone explain how this function is used please?

Fri, 20 Jun 2014 18:56:50 GMT

Hi,

You can try as

Hierarchy(FatherCode,ChildCode,Name)

Load

from

....,

so you can get a possible hierarchy and from that you can perform your calculations.

hope it helps

its_anandrjs — Fri, 20 Jun 2014 19:11:49 GMT

You can try like this way

Hierarchy:

HIERARCHY([Father Code], [Child Code], Name)

LOAD

[Father Code],

[Child Code],

Name

FROM

Location;

Or you can try this way from this post