Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

gumstero
New Contributor

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)

Tags (1)