topic Re: hieararchy in QlikView

hieararchy

emteam162 — Tue, 17 May 2016 20:39:49 GMT

Hi All,

I have a data set as shown below.

I want to make a tree structure by using Hierarchy function in QV

Niv1	Niv0	Name
1	0	NAME0
1N	1	NAME1
1N11	2	NAME2
2	0	NAME02
2B	1	NAME12
2B11	2	NAME22

The final resultat :

NAME0

NAME1

NAME2

Please help me.

Many thanks

Re: hieararchy

swuehl — Tue, 17 May 2016 20:44:00 GMT

Your Niv1 and Niv0 fields are not describing parent / child nodes, do they?

Could you describe a bit more detailed the logic / relation of your data?

Re: hieararchy

emteam162 — Tue, 17 May 2016 20:51:20 GMT

Field Values Niv0

0 is the top level

1 is the second level

2 is the last level

Re: hieararchy

santiago_respane — Tue, 17 May 2016 20:52:05 GMT

Hi Said,

Maybe you can start here:

Hierarchy function easy and Efficient with example---

Please let me know if this helps.

Kind regards,

Re: hieararchy

swuehl — Tue, 17 May 2016 21:00:19 GMT

You always have at most a single parent for a node and a single child?

Re: hieararchy

emteam162 — Tue, 17 May 2016 21:07:26 GMT

I tried that but not working

Re: hieararchy

emteam162 — Tue, 17 May 2016 21:14:15 GMT

yes

Re: hieararchy

swuehl — Tue, 17 May 2016 21:26:13 GMT

Maybe use something like

INPUT:

LOAD *, RecNO() as NodeID, If(Niv0=0,NULL(), Peek(NodeID)) as ParentID

INLINE [

Niv1, Niv0, Name

1, 0, NAME0

1N, 1, NAME1

1N11, 2, NAME2

2, 0, NAME02

2B, 1, NAME12

2B11, 2, NAME22

];

Hierarchy(NodeID, ParentID, Name,ParentName,Name, Path)

LOAD NodeID, ParentID, Name

Resident INPUT;

DROP TABLE INPUT;

Then create a listbox with option treeview enabled for field Path: