topic Re: hierarchy in the same column in QlikView

hierarchy in the same column

ceciliafujita — Fri, 12 Apr 2013 14:54:43 GMT

i have fathers and children in the same column. Father has the cod_name's lenght smaller than children's. How can i do the relationship between them?

what i have:

cod	name
1234	bla bla bla 1
89732738	bla bla bla 2
87852030	bla bla bla 3
98934796	bla bla bla 4
9876	bla bla bla 5
76656453	bla bla bla 6
76611453	bla bla bla 7

what i want:

cod	father
1234	bla bla bla 1
9876	bla bla bla 5

cod	children
89732738	bla bla bla 2
87852030	bla bla bla 3
98934796	bla bla bla 4
76656453	bla bla bla 6
76611453	bla bla bla 7

(till ther i know how to do)

relatioship:

father	children
1234	89732738
1234	87852030
1234	98934796
9876	76656453
9876	76611453

Have anyone any tip?

Re: hierarchy in the same column

Fri, 12 Apr 2013 16:31:24 GMT

Hi,

How do I know that 9876 is the father of 76611453?

Rebeca

Re: hierarchy in the same column

ceciliafujita — Fri, 12 Apr 2013 19:53:28 GMT

Because of the original order. The children always come after the father, but not directly at the subsequent line.

Thats my problem to do the relatioship... 😕

Re: hierarchy in the same column

kaushiknsolanki — Sat, 13 Apr 2013 07:08:41 GMT

Hi,

Have a look at the attachment.

Hope this is what you want.

Regards,

Kaushik Solanki

Re: hierarchy in the same column

Gysbert_Wassenaar — Sat, 13 Apr 2013 08:15:09 GMT

Something like this:

T1:

LOAD *,

if(len(cod)>=len(previous(cod)),alt(peek(parent),previous(cod))) as parent INLINE [

cod, name

1234, bla bla bla 1

89732738, bla bla bla 2

87852030, bla bla bla 3

98934796, bla bla bla 4

9876, bla bla bla 5

76656453, bla bla bla 6

76611453, bla bla bla 7

];

Replace the inline load with a load statement that load your data.

Re: hierarchy in the same column

ceciliafujita — Mon, 15 Apr 2013 12:47:07 GMT

Hello Kaushik,

In your solution i have to describe all the relationship, and that's my problem... what i need is how to automate the relationship.

Re: hierarchy in the same column

ceciliafujita — Mon, 15 Apr 2013 13:35:38 GMT

Hello Gysbert, you solved it!

Really thanks!