topic Re: Identify Duplicate Values & No Values in QlikView https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396309#M799172 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186768_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 13 Dec 2017 08:59:11 GMT tresB 2017-12-13T08:59:11Z Identify Duplicate Values & No Values https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396306#M799169 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a sample list below with Code and Description.&nbsp; I want to create the following:</P><P><STRONG>Duplicate Codes</STRONG>&nbsp; (those in red)</P><UL><LI>:&nbsp; A&nbsp; <STRONG>Chart Table</STRONG> Showing only those Codes that are duplicates</LI><LI>&nbsp;&nbsp; A <STRONG>Text Box</STRONG>,&nbsp; showing a count of those codes that are duplicates.&nbsp; (answer should be 5)</LI><LI></LI></UL><P style="font-size: 13.3333px;"><STRONG>Codes with No Description</STRONG>&nbsp; (those in blue)</P><UL><LI>:&nbsp; A&nbsp; <STRONG>Chart Table</STRONG> Showing only those Codes that have no description</LI><LI>&nbsp;&nbsp; A <STRONG>Text Box</STRONG>,&nbsp; showing a count of those codes that are duplicates.&nbsp; (answer should be 6)</LI></UL><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp; </P><P>Kind regards</P><P>Nayan</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 325px;"><TBODY><TR><TD class="xl67" height="17" width="98">Code</TD><TD class="xl65" style="border-left: none;" width="227">Description </TD></TR><TR><TD class="xl68" height="17" style="font-size: 8pt; color: #9c0006; font-family: Tahoma; border: 0.5pt solid gainsboro; background: #ffc7ce;">900</TD><TD class="xl66" style="border-top: none; border-left: none;">Cars</TD></TR><TR><TD class="xl68" height="17" style="font-size: 8pt; color: #9c0006; font-family: Tahoma; border: 0.5pt solid gainsboro; background: #ffc7ce;">900</TD><TD class="xl66" style="border-top: none; border-left: none;">Bikes</TD></TR><TR><TD class="xl68" height="17" style="font-size: 8pt; color: #9c0006; font-family: Tahoma; border: 0.5pt solid gainsboro; background: #ffc7ce;">2200</TD><TD class="xl66" style="border-top: none; border-left: none;">CLOSE CENTRE</TD></TR><TR><TD class="xl68" height="17" style="font-size: 8pt; color: #9c0006; font-family: Tahoma; border: 0.5pt solid gainsboro; background: #ffc7ce;">2200</TD><TD class="xl66" style="border-top: none; border-left: none;">CLOSED VENUE</TD></TR><TR><TD class="xl68" height="17" style="font-size: 8pt; color: #9c0006; font-family: Tahoma; border: 0.5pt solid gainsboro; background: #ffc7ce;">4200</TD><TD class="xl66" style="border-top: none; border-left: none;">MIAN</TD></TR><TR><TD class="xl68" height="17" style="font-size: 8pt; color: #9c0006; font-family: Tahoma; border: 0.5pt solid gainsboro; background: #ffc7ce;">4200</TD><TD class="xl66" style="border-top: none; border-left: none;">WEST</TD></TR><TR><TD class="xl68" height="17" style="font-size: 8pt; color: #9c0006; font-family: Tahoma; border: 0.5pt solid gainsboro; background: #ffc7ce;">5100</TD><TD class="xl66" style="border-top: none; border-left: none;">DETAILS</TD></TR><TR><TD class="xl68" height="17" style="font-size: 8pt; color: #9c0006; font-family: Tahoma; border: 0.5pt solid gainsboro; background: #ffc7ce;">5100</TD><TD class="xl66" style="border-top: none; border-left: none;">TRANSACTIONS</TD></TR><TR><TD class="xl68" height="17" style="font-size: 8pt; color: #9c0006; font-family: Tahoma; border: 0.5pt solid gainsboro; background: #ffc7ce;">7400</TD><TD class="xl66" style="border-top: none; border-left: none;">DURBAN</TD></TR><TR><TD class="xl68" height="17" style="font-size: 8pt; color: #9c0006; font-family: Tahoma; border: 0.5pt solid gainsboro; background: #ffc7ce;">7400</TD><TD class="xl66" style="border-top: none; border-left: none;">CAPE TOWN</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">1112</TD><TD class="xl66" style="border-top: none; border-left: none;">0000ABF</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">2870</TD><TD class="xl66" style="border-top: none; border-left: none;">0000ACA</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">3980</TD><TD class="xl66" style="border-top: none; border-left: none;">0000ADJ</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">7650</TD><TD class="xl66" style="border-top: none; border-left: none;">0000CHN</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">7850</TD><TD class="xl66" style="border-top: none; border-left: none;">0000FRQ</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">9320</TD><TD class="xl66" style="border-top: none; border-left: none;">0000RSE</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">7940</TD><TD class="xl66" style="border-top: none; border-left: none;">0000TXA</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;"><SPAN style="color: #3366ff;">7680</SPAN></TD><TD class="xl66" style="border-top: none; border-left: none;"><SPAN style="color: #3366ff;"> </SPAN></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;"><SPAN style="color: #3366ff;">7830</SPAN></TD><TD class="xl66" style="border-top: none; border-left: none;"><SPAN style="color: #3366ff;"> </SPAN></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;"><SPAN style="color: #3366ff;">6750</SPAN></TD><TD class="xl66" style="border-top: none; border-left: none;"><SPAN style="color: #3366ff;"> </SPAN></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;"><SPAN style="color: #3366ff;">2430</SPAN></TD><TD class="xl66" style="border-top: none; border-left: none;"><SPAN style="color: #3366ff;"> </SPAN></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;"><SPAN style="color: #3366ff;">9860</SPAN></TD><TD class="xl66" style="border-top: none; border-left: none;"><SPAN style="color: #3366ff;"> </SPAN></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;"><SPAN style="color: #3366ff;">6720</SPAN></TD><TD class="xl66" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396306#M799169 Anonymous 2020-11-25T16:16:04Z Re: Identify Duplicate Values & No Values https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396307#M799170 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">To find duplicate records<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count (If(Aggr(Count(code),code)&gt;1,code) <STRONG>)</STRONG><STRONG> </STRONG></SPAN></P></BODY></HTML> Wed, 13 Dec 2017 08:49:23 GMT https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396307#M799170 Anonymous 2017-12-13T08:49:23Z Re: Identify Duplicate Values & No Values https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396308#M799171 <HTML><HEAD></HEAD><BODY><P>Hi Aparna,</P><P></P><P>Thank you for your reply.&nbsp; However, the answer i get is zero.</P><P></P><P>Kind regards,</P><P>Nayan</P></BODY></HTML> Wed, 13 Dec 2017 08:58:47 GMT https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396308#M799171 Anonymous 2017-12-13T08:58:47Z Re: Identify Duplicate Values & No Values https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396309#M799172 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186768_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 13 Dec 2017 08:59:11 GMT https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396309#M799172 tresB 2017-12-13T08:59:11Z Re: Identify Duplicate Values & No Values https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396310#M799173 <HTML><HEAD></HEAD><BODY><P>Hi Tressco,</P><P></P><P>It worked.&nbsp; Thank you.</P><P></P><P>Kind regards,</P><P>Nayan</P></BODY></HTML> Wed, 13 Dec 2017 09:07:31 GMT https://community.qlik.com/t5/QlikView/Identify-Duplicate-Values-No-Values/m-p/1396310#M799173 Anonymous 2017-12-13T09:07:31Z