Hierarchy :not working

gizzel123 — Sun, 13 Mar 2016 13:34:50 GMT

Hi Guys,

I am trying to create a hierarchy with child and parent nodes. But the Path is not creating.

Could you please help.

Thanks.

Re: Hierarchy :not working

swuehl — Sun, 13 Mar 2016 14:30:56 GMT

Your root nodes should be listed as child without a parent, e.g. by using

BOM:
LOAD BOM_ASSEMBLY_PRODUCT, 
    BOM_COMPONENT_PRODUCT, 
    BOM_PARENT, 
    BOM_CHILD, 
    BOM_QTY_COMPONENT
FROM
[BOM_QVD.QVD]
(qvd);

CONCATENATE (BOM)
LOAD BOM_PARENT as BOM_CHILD,
  NULL() as BOM_PARENT,
 BOM_ASSEMBLY_PRODUCT as BOM_COMPONENT_PRODUCT
RESIDENT BOM WHERE NOT EXISTS(BOM_CHILD,BOM_PARENT);

BOM_HIER:
Hierarchy (BOM_CHILD, BOM_ASSEMBLY, BOM_COMPONENT, BomAssemblyName,BOM_COMPONENT, Path, '/', Depth)
//Hierarchy (BOM_CHILD, BOM_ASSEMBLY, BOM_COMPONENT,  [ParentName], [PathSource], [PathName], '/', [Depth])
LOAD 
 BOM_CHILD,
 BOM_CHILD AS BOM_COMPONENT, 
 BOM_PARENT AS BOM_ASSEMBLY
RESIDENT BOM;

Re: Hierarchy :not working

gizzel123 — Mon, 14 Mar 2016 13:53:24 GMT

Thanks

topic Re: Hierarchy :not working in QlikView

Hierarchy :not working

Re: Hierarchy :not working

Re: Hierarchy :not working