topic Re: Finding missing records in QlikView

Finding missing records

isciberras — Sat, 16 Nov 2024 03:25:46 GMT

Hi everyone,

I need some help, I have a table with teams and their associated assets as shown in the table below

Team	Assets
A	books
B	books
C	books
A	Radio
B	Radio
C	Radio
D	Radio

So from the table above I can see that Team A,B,C have books however Team D does not. We can identify that a Team D exists because Team D has a radio.

Does anyone know what syntax I can write to identify that team D does not own the asset 'books'

Thanks,

Isaac

Re: Finding missing records

sunny_talwar — Thu, 30 May 2019 12:11:07 GMT

Where exactly are you looking to show this information? and do you just need to display the name of the Team which doesn't have all the assets or do you need to display the name of the Asset as well?

Re: Finding missing records

isciberras — Thu, 30 May 2019 12:30:02 GMT

Thank you for your help.

Im hoping to create a table which looks like:

Assets	Team that does not have Asset
Books	D

Re: Finding missing records

Anil_Babu_Samineni — Fri, 31 May 2019 14:58:51 GMT

If source having like below including your sample data, Then what is the expected output?

Team, Assets
D, books
E, books
F, Radio