Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Subtracting a matching value across 2 data sets

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.

Bernie Malkowski
1 Solution

Accepted Solutions
Contributor II
Contributor II

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.

Bernie Malkowski

View solution in original post

2 Replies
Partner
Partner

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

 

 

Contributor II
Contributor II

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.

Bernie Malkowski

View solution in original post