Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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

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)