topic Re: Subtracting a matching value across 2 data sets in QlikView

Subtracting a matching value across 2 data sets

bmalkows — Wed, 25 Nov 2020 16:16:04 GMT

I am newer to set analysis and have an application where I am analyzing bill of material (BOM) data sets (spreadsheet imports).

Given a matching value from one data set to another I would like to subtract values (in table form).

More specfically, if I have a matching part number ("material") in two different BOM's I would like to subtract their unit costs to see if the price is the same, and/ or there are more parts in another BOM.

My BOM's are organized in 7 digit numbers: 2 BOM's 3762416 and 3762408

Here is my set of materials for 3762416 =[3762416.3762416.Material]

Here is my set of materials for 3762408 =[3762408.3762408.Material]

Summing of unit costs:

Sum([3762416.3762416.EPP in USD])

Sum([3762408.3762408.EPP in USD])

Please offer any set expression that may accomplish this.

Re: Subtracting a matching value across 2 data sets

Arthur_Fong — Thu, 22 Aug 2019 07:32:06 GMT

Could you please attach a sample app?

It is crucial to know how the datasets are being linked or joined together.

Thanks and regards,

Arthur Fong

Re: Subtracting a matching value across 2 data sets

bmalkows — Thu, 22 Aug 2019 14:02:47 GMT

Thank you for the prompt response - I have made some headway by modifying the load script (unlocked it) via associating all the BOMs with a key - "MatKey" and it seems to be working. I am all set for now.