Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sbfernandes
Contributor III
Contributor III

Display only those records which have one particular value for all records

Greetings! I hope i can explain this well enough. I have a table with columns Number, Col1, Col2 which can be considered as a unique identifier. Column Flag shows a value which corresponds to Col3 (if it exists or not). I require to show a straight table that will display only those records in Number, Col1, Col 2 where all values in column Flag = "Exists". If even one record has a "Not Exists", then it should be excluded from the table. Please see attachment. Thank you.
1 Solution

Accepted Solutions
raman_rastogi
Partner - Creator III
Partner - Creator III

Try this Expression
if(Aggr(Only(Flag),Number)='Exists','AllFlagExists')
And exclude Zero Values

View solution in original post

2 Replies
raman_rastogi
Partner - Creator III
Partner - Creator III

Try this Expression
if(Aggr(Only(Flag),Number)='Exists','AllFlagExists')
And exclude Zero Values
sbfernandes
Contributor III
Contributor III
Author

Thanks! This works perfectly.