Complicated bill of materials - Qlik Community

jozisvk11 · ‎2017-10-24

Hello, I have a problem with the bill of material. I need to count quantity of material, which is used in different level of bill of materials. I have the table:

ITEM ITEM/MATERIAL QUANTITY

V0900 V0901 1

M0100 2

M0101 2

V0901 V0902 2

M0100 3

M0102 2

V0902 V0903 1

M0104 5

M0105 10

V0903 M0107 20

...

Now I need to find, how much material (Material is item starts with M****) I need to Item for example V0900.

Result should be:

ITEM MATERIAL QUANTITY

V0900 M0100 5

V0900 M0101 2

V0900 M0102 2

V0900 M0104 10 (V0902 is 2 times, so 2x5)

V0900 M0105 20 (V0902 is 2 times, so 2x10)

V0900 M0107 40 (V0902 is 2 times, so 1x2x20)

Could you help me witm my problem ?

Thank you.

felipedl · ‎2017-10-26

Hi Jozef,

For the data you provided, I've come to code something that makes a dynamic listing of the ITEMs you have.

For now, I've just put up a total sum of material quantity (without specifying the MATERIAL) for each individiual item.

I'll try to put the materials in it too later.

See the attached QVW.

Felipe.