Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Leverage your QlikView investment to modernize BI – see how! Join Group
Showing results for 
Search instead for 
Did you mean: 

Want to find duplicate records


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)


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

Tags (1)