topic Re: Hierarchy in QlikView in QlikView

Hierarchy in QlikView

rishimessi19 — Sat, 16 Nov 2024 01:52:39 GMT

I have the below sample data displaying the L1, L2 & L3 hierarchies

L1	L2	L3
A
A	B
A	B	F
A	B	G
A	C
A	C	H
A	D
A	D	I
A	D
A	E	J
A	E	K

The requirement is to to transform the above table into the 2 tables mentioned below. Can someone please help me with this?

Table 1:

Manager	Emp
A	A
A	B
A	C
A	D
A	E
A	F
A	G
A	H
A	I
A	J
A	K
B	B
B	F
B	G
C	C
C	H
D	D
D	I
E	E
E	J
E	K

Table 2:

Manager	Emp
A	B
A	C
A	D
A	E
A	F
A	G
A	H
A	I
A	J
A	K
B	F
B	G
C	H
D	D
D	I
E	J
E	K

Re: Hierarchy in QlikView

chrismarlow — Sat, 23 Nov 2019 16:47:10 GMT

Hi,

Think this is Table 1 - to get you started.

Cheers,

Chris.

data: LOAD * INLINE [ L1, L2, L3 A,, A, B, A, B, F A, B, G A, C, A, C, H A, D, A, D, I A, D, A, E, J A, E, K ]; data_final: Load Distinct L1 AS Manager, If(IsNull(L2) or L2='',L1,L2) AS Emp Resident data; Concatenate (data_final) Load Distinct L1 AS Manager, L3 AS Emp Resident data where not (IsNull(L3) or L3=''); Concatenate (data_final) Load Distinct L2 AS Manager, If(IsNull(L3) or L3='',L2,L3) AS Emp Resident data where not (IsNull(L2) or L2='');

Re: Hierarchy in QlikView

Brett_Bleess — Thu, 05 Dec 2019 20:59:49 GMT

The only thing I have in addition to Chris' post is the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

That might be useful to a degree. If Chris' post got you on the right track, be sure to come back and use the Accept as Solution button on it to give them credit for the assistance and let other Community Members know it helped.

Regards,
Brett