Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

amiumi66
New Contributor III

Question on dupes

I have two fields like below.

StudentHead Teacher
LucasMr Kien
johnMs Amily
TriciaMr Muro
DebMs Henry
TrumpMr Kien
KevinMs Corrine

Each student is suppose to have 1 head teacher. How can you identify students that has 2 head teachers and vice versa.

1 Solution

Accepted Solutions
mdmukramali
Valued Contributor II

Re: Question on dupes

Hi,

=Count({<Student={"=Count( [Head Teacher])>=2"}>}Student)

2 Replies
mdmukramali
Valued Contributor II

Re: Question on dupes

Hi,

=Count({<Student={"=Count( [Head Teacher])>=2"}>}Student)

amiumi66
New Contributor III

Re: Question on dupes

can you also do solution with aggr function?

Community Browser