topic Re: Re: Parts hierarchy in QlikView

Hierarchy GUI and Script Problem

Wed, 16 Oct 2013 06:03:28 GMT

Hello,

I have some issue on my project.

I have 2 main tables:

Parts table:

Part Arc table:

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

Station 1	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

Station 1

Station 3

Station 4

Many Thanks for your support,

Itsik

vikasmahajan — Wed, 16 Oct 2013 09:34:13 GMT

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

Vikas

Thu, 17 Oct 2013 10:15:51 GMT

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

I tried to do so unsuccessfully...