topic How does one check for duplicate entries in a field in QlikView https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428181#M807111 <HTML><HEAD></HEAD><BODY><P>how does one check for duplicate entries in a field , and identify maximum value with duplicate entries?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ramcena306 2020-11-25T16:16:04Z How does one check for duplicate entries in a field https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428181#M807111 <HTML><HEAD></HEAD><BODY><P>how does one check for duplicate entries in a field , and identify maximum value with duplicate entries?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428181#M807111 ramcena306 2020-11-25T16:16:04Z Re: How does one check for duplicate entries in a field https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428182#M807112 <HTML><HEAD></HEAD><BODY><P>May be create a straight table like this</P><P></P><P>Dimension</P><P><STRONG>FieldName</STRONG></P><P></P><P>Expression</P><P><STRONG>Count(FieldName)</STRONG></P></BODY></HTML> Wed, 25 Oct 2017 09:01:48 GMT https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428182#M807112 sunny_talwar 2017-10-25T09:01:48Z Re: How does one check for duplicate entries in a field https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428183#M807113 <HTML><HEAD></HEAD><BODY><P>Or in a textbox:</P><P><EM>=Max(Aggr(Count(FieldName), FieldName))</EM></P></BODY></HTML> Wed, 25 Oct 2017 09:13:20 GMT https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428183#M807113 jonathandienst 2017-10-25T09:13:20Z Re: How does one check for duplicate entries in a field https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428184#M807114 <HTML><HEAD></HEAD><BODY><P>show that field in listbox and check frequency option and also select frequency option under sort tab of list box properties(ascending/descending).it shows the count of repetitions of the field records.</P></BODY></HTML> Wed, 25 Oct 2017 09:33:51 GMT https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428184#M807114 omkarvamsi 2017-10-25T09:33:51Z Re: How does one check for duplicate entries in a field https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428185#M807115 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Another way via front,</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180846_Capture.JPG" style="height: 349px; width: 620px;" /></P></BODY></HTML> Wed, 25 Oct 2017 09:36:08 GMT https://community.qlik.com/t5/QlikView/How-does-one-check-for-duplicate-entries-in-a-field/m-p/1428185#M807115 devarasu07 2017-10-25T09:36:08Z