topic HIERARCHY in QlikView

HIERARCHY

tizianacaem — Tue, 15 May 2012 11:21:43 GMT

hi all,
I have a problem whit 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 child 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
F	G	1

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, 6F, 6G

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

Any ideas please?

thank

Re: HIERARCHY

Tue, 15 May 2012 11:54:29 GMT

Hi,

I have solve this problem with the attached example. It's a long way in script, but it works.

Regards Vicky

HIERARCHY

tizianacaem — Wed, 16 May 2012 09:03:53 GMT

Hi Vicky,

thanks very much for your answer, but my problem is that i don't know how many levels the bills of material is composed of, and so your example is not adaptable. any other ideas?

thanks

Tiziana