Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
tomerdagan123
Contributor III
Contributor III

creating flat table BOM

HI,

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

ParentChildTypeQty
ABMake2
AEBuy1
AFBuy1
BCMake2
CDBuy2
DGMake1
GHBuy1

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

ParentChildTypeQtyLevel
AAMake10
ABMake21
ACMake42
ADBuy83
AEBuy11
AFBuy11
BBMake10
BCMake21
BDBuy42
DDMake10
DGMake11
DHBuy12
GGMake10
GHBuy11

Any idea?

2 Replies
santhosh_k_n
Creator II
Creator II

Hi,

Please go through the following link,

Qlik Design Blog

BR,

SK

marcus_sommer
MVP & Luminary
MVP & Luminary

See: Bill of Materials

- Marcus