Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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.