topic Hierarchy and Depths in QlikView

Hierarchy and Depths

Dayna — Wed, 15 Dec 2010 14:51:25 GMT

Dear all,

I have been trying to achieve a Bill of Materials using various functions, and finally I was able to achieve (I think!) what I needed using the HierarchyBelongsTo function…

However, my costs are wrong as the higher level components include the costs for the lower level, so what I need to do is ignore the cost for any component that has a sub component. But how do I go about calculating which item belongs to which?

Here is an example output of data:

Comp	LL Cost Comp	TL Cost Comp	Depth
SA9500FW1	0.206807692	0	0
SA9500FW2	0.219461539	0	0
6852A	0	0.228	1
20935H	0	0.0198	1
20940H	0	0.0198	1
4488	0.23199834	0	1
4489	0.23043029	0	1
5011	0	0	1
5011	0	5	1
5011	0	7.5	1
6857	0	0.159	1
10859	0	0	1
10859	0	0.003744164	1
10859	0	0.00425	1
10859	0	0.0139	1
31055	0	0.1354	1
7008	0	0	2
7008	0	83	2
7008	0	104.89	2
7035	0	0	2
7035	0	29.5	2
7035	0	62.1	2
7143	0	0	2
7143	0	2.92	2
7143	0	3.1	2
7143	0	3.17	2
7157	0	0	2
7157	0	1.89	2
7157	0	2.24	2
7173	0	0	2
7173	0	6.89	2
7173	0	9.7	2
7241	0	0	2
7241	0	12.8	2
7241	0	13.73	2
7244	0	0	2
7244	0	1.8	2
7244	0	2.3	2
7246	0	0	2
7246	0	2.9	2
7246	0	3.49	2
7259	0	0	2
7259	0	3.15	2
7259	0	4.6	2
7304	0	0	2
7304	0	0.195	2
7304	0	0.31	2
7428	0	0	2
7428	0	16.35060001	2
7428	0	16.43919	2
7440	0	0	2
7440	0	3.507457604	2
7440	0	4.5	2

Many thanks for any help you could provide!!

Kind Regards,
Dayna

Hierarchy and Depths

Dayna — Fri, 17 Dec 2010 10:27:51 GMT

Does anybody have any idea?

Hierarchy and Depths

Fri, 17 Dec 2010 11:30:59 GMT

why not do this? (set analysis?)

Hierarchy and Depths

Fri, 17 Dec 2010 11:40:10 GMT

or this? Maybe better?

Hierarchy and Depths

Dayna — Fri, 17 Dec 2010 14:15:27 GMT

Hello Jochem,

Thank you so much for your response, unfortunately I've tried the application but I would need it to show the sub component, as each product may have components that go in it...

Here was an example set of data I had previously uploaded:

http://community.qlik.com/forums/p/35985/141424.aspx#141424

Kind Regards,
Dayna

Hierarchy and Depths

Fri, 17 Dec 2010 14:26:57 GMT

isn't the second example what you mean with this?

Hierarchy and Depths

Dayna — Fri, 17 Dec 2010 14:47:41 GMT

Hello Jochem,

The second example shows the top level, but doesn't seem to show the sub components. Please see below:

Hierarchy and Depths

Fri, 17 Dec 2010 15:27:32 GMT

can you send me your qvw?? because i'm missing some things (parts)

Hierarchy and Depths

Fri, 17 Dec 2010 15:36:58 GMT

about your other post

Hierarchy and Depths

Dayna — Fri, 17 Dec 2010 16:28:50 GMT

Please find attached 🙂

Hierarchy and Depths

Fri, 17 Dec 2010 16:59:46 GMT

IS this what you mean?

Hierarchy and Depths

Dayna — Fri, 17 Dec 2010 17:41:05 GMT

I will have a look and let you know! Thanks Jochem!

Hierarchy and Depths

Thu, 23 Dec 2010 09:52:33 GMT

IS YOUR PROBLEM SOLVED??

Hierarchy and Depths

Dayna — Wed, 29 Dec 2010 10:06:42 GMT

Jochem,

I have been on annual leave, so I don't know if it resolves my issue 100%. But it seems to break down the components.

Many thanks,
Dayna

Re: Hierarchy and Depths

Fri, 10 Jan 2014 13:07:39 GMT

Hi Jochem

I see your qvw about this topic, also I have a question for you.

It's possible with the semi-elaborate products has the BOM explossion with hierarchy

Let me explain

You have a Final Product with this formula, but in the formula you have a code who has his own formula

I have maybe 3 or 4 levels in some products. Any Ideas?

The final output its only have materials requirements with the semi-elaborate requirements.

thank you