topic Re: Hierarchy with one field in QlikView

Hierarchy with one field

juan_patrick — Fri, 28 Nov 2014 12:23:57 GMT

Hi, I have a table that contains a field with this information:

h_wbs (field)

15.1

15.1.1

15.2

15.3

16.1

16.1.1

16.1.1.1

17.1

18.1

18.2

18.2.1

18.2.1.1

I want to use hierarchy to show eacho "node" inside his parent, egg: the parent of 16.1.1.1 is 16.1.1 and the parent of this is 16.1, etc

I use the function but cant resolve to show as I want!

¡Thank you very much!

Re: Hierarchy with one field

Gysbert_Wassenaar — Fri, 28 Nov 2014 12:51:07 GMT

Something like this:

Data:
Hierarchy(Node,ParentNode,NodeName,ParentName,NodeName,Path,'/',Depth)
LOAD
  text(Node) as Node,
  text(Node) as NodeName,
  text(left(Node,index(Node,'.',-1)-1)) as ParentNode
INLINE [
    Node
    15
    15.1
    15.1.1
    15.2
    15.3
    16
    16.1
    16.1.1
    16.1.1.1
    17
    17.1
    18
    18.1
    18.2
    18.2.1
    18.2.1.1
];

Re: Hierarchy with one field

juan_patrick — Fri, 28 Nov 2014 12:55:39 GMT

Not exactly, I want to do a tree view with expand nodes

Re: Hierarchy with one field

Gysbert_Wassenaar — Fri, 28 Nov 2014 13:22:18 GMT

Add the Path field in a listbox and enable the Show as Treeview option.

Re: Hierarchy with one field

juan_patrick — Fri, 28 Nov 2014 13:31:14 GMT

¡Thank you very much!