creating flat table BOM

[Anonymous]

HI,

I'm attempting to perform a bill of materials explosion in QV using Hierarchy & HierarchyBelongsTo. My data looks something like this:

Parent	Child	Type	Qty
A	B	Make	2
A	E	Buy	1
A	F	Buy	1
B	C	Make	2
C	D	Buy	2
D	G	Make	1
G	H	Buy	1

My goal it to get a flat table depicting the total BOM structure. The resulting table would look something like this:

Parent	Child	Type	Qty	Level
A	A	Make	1	0
A	B	Make	2	1
A	C	Make	4	2
A	D	Buy	8	3
A	E	Buy	1	1
A	F	Buy	1	1
B	B	Make	1	0
B	C	Make	2	1
B	D	Buy	4	2
D	D	Make	1	0
D	G	Make	1	1
D	H	Buy	1	2
G	G	Make	1	0
G	H	Buy	1	1

Any idea?

[santhosh_k_n]

Hi,

Please go through the following link,

Qlik Design Blog

BR,

SK

[marcus_sommer]

See: Bill of Materials

- Marcus