Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Want to find duplicate records

Hi,

There's a status for persons in the database.

I want to remove persons in a list that have the status L or W in combination with status B or if L or W occurs more than two times per person.

I want to do that in a straight table and not in the script.

Been experimenting with a few things but haven't cracked the complete code.

Any help is welcome.

Below are some of the expressions I've been trying to get the correct result with.

=COUNT({(<STATUS = {L}> + <STATUS = {B}>) * (<STATUS = {L}> + <STATUS = {W}>)} PERSON)

=sum(if(Aggr(Count(DISTINCT(STATUS)),STATUS)>=2,1))

if(aggr( Concat(len(STATUS)>2),1,2),STATUS)

0 Replies