topic Any example app for creating Hierarchy? in QlikView

Any example app for creating Hierarchy?

Sat, 24 Sep 2016 10:42:50 GMT

HI All.

Can any tell me how to create hierarchy or the steps.

Regards,

Helen

raghvendrasingh — Sat, 24 Sep 2016 11:53:01 GMT

Hi,

Please look into it, it will resolve your concern.

Regards,

Raghvendra

el_aprendiz111 — Sat, 24 Sep 2016 13:56:07 GMT

hello,

Anil_Babu_Samineni — Sat, 24 Sep 2016 14:34:34 GMT

Don't create Double threads

miguelbraga — Sat, 24 Sep 2016 15:14:59 GMT

Hey there,

I guess what you really need is all here:

Simple example:

In script:

Hierarchy(NodeID, ParentID, NodeName, ParentName, NodeName, PathName, '\', Depth) LOAD * inline [

NodeID, ParentID, NodeName

1, 4, London

2, 3, Munich

3, 5, Germany

4, 5, UK

5, , Europe

];

What you get in straight table:

Che the output in my attached file:

Best regards,

D.A. MB