Hierarchy GUI and Script Problem - Qlik Community

Report Inappropriate Content · ‎2013-10-16

Hello,

I have some issue on my project.

I have 2 main tables:

Parts table:

Part ID	Part Name	Balance
1	A	10
2	B	25
3	C	66
4	D	4
5	E	86
6	F	20
7	G	40
8	H	81
9	K	98

Part Arc table:

Part ID	Son ID
2	1
3	1
6	1
7	1
4	2
5	4
8	3
8	9

My desirable result is some straight table or something like this with this following data:

Station 1

Station 3

Station 4

A

10

B

25

D

4

E

86

A

10

C

66

H

81

A

10

F

20

A

10

G

40

K

98

H

81

Many Thanks for your support,

Itsik

vikasmahajan · ‎2013-10-16

Base on Parent Id you need to apply left join and load the same in qlikview and use cross table functionality.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-10-17

I'd be very grateful if you can try to do so on the attached example.

I tried to do so unsuccessfully...