Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
isciberras
Creator
Creator

Finding missing records

Hi everyone, 

 

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

TeamAssets
Abooks 
Bbooks 
Cbooks
ARadio
BRadio
CRadio
DRadio

 

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

 

Labels (2)
3 Replies
sunny_talwar

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?

isciberras
Creator
Creator
Author

Thank you for your help. 

 

Im hoping to create a table which looks like:

AssetsTeam that does not have Asset
BooksD
  
  
  
  
  
  
  
  

 

 

 

Anil_Babu_Samineni

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

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)