Problem with Hierarchy

tizianacaem — Fri, 18 May 2012 09:36:22 GMT

hi all,
I have a problem with the linearization of the bills of material.
I have a table which has on the same line the parent code and child code, with the use's factor for son.

The sono code can become a father in another row, with the relative use's factor.
eg.

FATHER	SON	FACTOR-USE
A	B	2
A	C	3
B	D	1
C	E	2
C	F	2
D	F	1
G	H	1
H	E	2

I want the linearization of the bill, so that I can bind the parent code and how many children are need to make the father.

eg. father A needs 2B, 3C, 2D, 6E, 8F Father G needs 1H, 2E etc.

I did experiment with the function Hierarchy, but I can't able to define the use's factor.

Any ideas please?

thanks

Tiziana

Problem with Hierarchy

adnan_rafiq — Fri, 18 May 2012 13:05:22 GMT

I am not really sure about your exact requirment

but i guess here is the logic that might be helpful

load Hiearchy repeatedly see below script to get an idea.

It will create link with one hierarchy table to other you will see like

A is linked to C and B and also E , F through C and B and so on

Hierarchy (SON, FATHER,A)

LOAD FATHER,

SON,

'Dum' as A

FROM

[Hiearchy test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Hierarchy ( SON_1,SON, B)

LOAD FATHER as SON,

SON as SON_1 ,

'Dum' as B

FROM

[Hiearchy test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Hierarchy ( SON_2,SON_1, C)

LOAD FATHER as SON_1,

SON as SON_2 ,

'Dum' as C

FROM

[Hiearchy test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Regards

topic Problem with Hierarchy in QlikView

Problem with Hierarchy

Problem with Hierarchy