topic Re: Question on dupes in QlikView https://community.qlik.com/t5/QlikView/Question-on-dupes/m-p/1462407#M610647 <HTML><HEAD></HEAD><BODY><P>can you also do solution with aggr function?</P></BODY></HTML> Wed, 10 Jan 2018 18:25:32 GMT userid128223 2018-01-10T18:25:32Z Question on dupes https://community.qlik.com/t5/QlikView/Question-on-dupes/m-p/1462405#M610645 <HTML><HEAD></HEAD><BODY><P>I have two fields like below.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Student</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Head Teacher</STRONG></TH></TR><TR><TD style="padding: 2px;">Lucas</TD><TD style="padding: 2px;">Mr Kien</TD></TR><TR><TD style="padding: 2px;">john</TD><TD style="padding: 2px;">Ms Amily</TD></TR><TR><TD style="padding: 2px;">Tricia</TD><TD style="padding: 2px;">Mr Muro</TD></TR><TR><TD style="padding: 2px;">Deb</TD><TD style="padding: 2px;">Ms Henry</TD></TR><TR><TD style="padding: 2px;">Trump</TD><TD style="padding: 2px;">Mr Kien</TD></TR><TR><TD style="padding: 2px;">Kevin</TD><TD style="padding: 2px;">Ms Corrine</TD></TR></TBODY></TABLE><P></P><P></P><P>Each student is suppose to have 1 head teacher. How can you identify students that has 2 head teachers and vice versa. </P></BODY></HTML> Wed, 10 Jan 2018 17:28:06 GMT https://community.qlik.com/t5/QlikView/Question-on-dupes/m-p/1462405#M610645 userid128223 2018-01-10T17:28:06Z Re: Question on dupes https://community.qlik.com/t5/QlikView/Question-on-dupes/m-p/1462406#M610646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>=Count({&lt;Student={"=Count( [Head Teacher])&gt;=2"}&gt;}Student)</P></BODY></HTML> Wed, 10 Jan 2018 18:01:49 GMT https://community.qlik.com/t5/QlikView/Question-on-dupes/m-p/1462406#M610646 mdmukramali 2018-01-10T18:01:49Z Re: Question on dupes https://community.qlik.com/t5/QlikView/Question-on-dupes/m-p/1462407#M610647 <HTML><HEAD></HEAD><BODY><P>can you also do solution with aggr function?</P></BODY></HTML> Wed, 10 Jan 2018 18:25:32 GMT https://community.qlik.com/t5/QlikView/Question-on-dupes/m-p/1462407#M610647 userid128223 2018-01-10T18:25:32Z