topic Re: BOM - Hierarchy in App Development

BOM - Hierarchy

df_qlik — Wed, 18 Sep 2024 14:40:54 GMT

Dear all,

currently I'm trying to display multidimensional BOM's in Qlik Sense. I already read every community post. but unfortunately it did not help me.
In my original BOM table there is the ParentID, ChildID, ParentMaterialNo, ChildMaterialNo, ParentDescription, ChildDescription and Quantity. What is missing is the field 'Level' or 'Depth' or something like that. At the moment I'm just able to display a one-dimensional BOM. What I need is at least a two-dimensional BOM and in the best case all the dimensions.
The result table should look like that:

Level | ParentMaterialNo | ParentDescription | ChildMaterialNo | ChildDescription | Quantity

I would be very grateful for your help!

Re: BOM - Hierarchy

Oleg_Troyansky — Wed, 18 Sep 2024 17:58:21 GMT

Hi,

I can see two possible ways to solve this problem:

1. You can "flatten" the BOM by loading a pre-defined number of levels into a single table, with separate fields for each level's material, quantity, etc...

2. You can load the hierarchical data into a hierarchical data structure, using keywords "Hierarchy" and "HierarchyBelongsTo"

See Qlik Sense Help for these topics:

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/Hierarchy.htm

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/HierarchyBelongsTo.htm

Cheers,

Re: BOM - Hierarchy

df_qlik — Thu, 19 Sep 2024 06:32:55 GMT

Hi Oleg,

thank you for replying. Actually I tried to use both functions "Hierarchy" and "HierarchyBelongsTo", but did not get the desired result.

That's what I tried:

BOM_Hierarchy:
Hierarchy(ChildID, ParentID, NodeName, 'ParentPath','/' ,Depth)
LOAD
  ParentID,
  ChildID,
  ParentMaterialNo,
ChildMaterialNo,
ParentDescription,
ChildDescription,
  ChildDescription as NodeName,
Quantity
FROM [lib://QVD/BOM.qvd]

Do you have an advice? With the script above I can see the Depth, but I still can not display more than two levels (Parent and the child directly below).

Thank you in advance!

Best regards, Till