Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
juan_patrick
Creator
Creator

Hierarchy with one field

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

h_wbs (field)

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

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!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

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

];


talk is cheap, supply exceeds demand
juan_patrick
Creator
Creator
Author

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
juan_patrick
Creator
Creator
Author

¡Thank you very much!