topic Re: Display All Duplicate Records in QlikView https://community.qlik.com/t5/QlikView/Display-All-Duplicate-Records/m-p/805053#M284215 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="80797" alt="hi-wave.gif" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80797_hi-wave.gif" style="height: auto;" /> <STRONG style=": ; color: #ff0000; font-size: 12pt;">ROB</STRONG><IMG __jive_id="80801" alt="thank-you.gif" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/80801_thank-you.gif" style="height: auto;" /><IMG __jive_id="80802" alt="nice-day-smiley-emoticon.gif" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/80802_nice-day-smiley-emoticon.gif" style="height: auto;" /></P></BODY></HTML> Mon, 16 Mar 2015 06:24:23 GMT tamilarasu 2015-03-16T06:24:23Z Display All Duplicate Records https://community.qlik.com/t5/QlikView/Display-All-Duplicate-Records/m-p/805051#M284213 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is there any way to display all the duplicate records in a chart. I have<SPAN style="font-size: 13.3333330154419px;"> duplicate values in </SPAN>field <STRONG>%CustProd</STRONG> and I need to show the both file names and <SPAN style="font-size: 13.3333330154419px;">%CustProd like below. I have to do this in expression. Can anyone guide me.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><IMG __jive_id="80779" alt="Capture.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80779_Capture.PNG" style="height: 206px; width: 620px;" /><BR /></SPAN></P><P></P><P>Attached sample file also</P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Thank you in advance.</SPAN></P></BODY></HTML> Mon, 16 Mar 2015 03:35:34 GMT https://community.qlik.com/t5/QlikView/Display-All-Duplicate-Records/m-p/805051#M284213 tamilarasu 2015-03-16T03:35:34Z Re: Display All Duplicate Records https://community.qlik.com/t5/QlikView/Display-All-Duplicate-Records/m-p/805052#M284214 <HTML><HEAD></HEAD><BODY><P>You should be able to display the duplicates with a calculated dimension of:</P><P><SPAN style="font-family: 'courier new', courier;">=if(</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">aggr(Count(%CustProd)&gt;1,%CustProd)</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">,%CustProd)</SPAN></P><P></P><P>and a second Dimension of Filename. Uncheck "suppress zero values" on Presentation. See attached.</P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://masterssummit.com" rel="nofollow">http://masterssummit.com</A></P><P><A class="jive-link-external-small" href="http://robwunderlich.com" rel="nofollow">http://robwunderlich.com</A></P></BODY></HTML> Mon, 16 Mar 2015 05:49:44 GMT https://community.qlik.com/t5/QlikView/Display-All-Duplicate-Records/m-p/805052#M284214 rwunderlich 2015-03-16T05:49:44Z Re: Display All Duplicate Records https://community.qlik.com/t5/QlikView/Display-All-Duplicate-Records/m-p/805053#M284215 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="80797" alt="hi-wave.gif" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80797_hi-wave.gif" style="height: auto;" /> <STRONG style=": ; color: #ff0000; font-size: 12pt;">ROB</STRONG><IMG __jive_id="80801" alt="thank-you.gif" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/80801_thank-you.gif" style="height: auto;" /><IMG __jive_id="80802" alt="nice-day-smiley-emoticon.gif" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/80802_nice-day-smiley-emoticon.gif" style="height: auto;" /></P></BODY></HTML> Mon, 16 Mar 2015 06:24:23 GMT https://community.qlik.com/t5/QlikView/Display-All-Duplicate-Records/m-p/805053#M284215 tamilarasu 2015-03-16T06:24:23Z