topic Re: How to detect duplicate? in QlikView https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657402#M1083914 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>Dimension : Employee</P><P>Expression :</P><P>Status ----- If(Count(Distinct StatusId)&gt;1, 'Status')</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Duplicate ID</SPAN>----- If(Count(Distinct StatusId)&gt;1, Concat(StatusId, ','))</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 26 Jun 2014 05:20:55 GMT jagan 2014-06-26T05:20:55Z How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657398#M1083910 <HTML><HEAD></HEAD><BODY><P>Employee&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; StatusId</P><P>Alex&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Submit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1</P><P>Alex&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Submit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2</P><P>Alice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In progress&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B1</P><P>Jack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Submit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C1</P><P>Jack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In progress&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C2</P><P></P><P></P><P></P><P></P><P>What formula should i use,I want to show If employee has more than one status then it is duplicate and show the duplicate id.</P><P></P><P></P><P>The result should be:</P><P></P><P>Employee&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Duplicate ID</P><P>Alex&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Duplicate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1,A2</P><P>Jack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Duplicate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C1,C2</P><P></P><P>TQ</P></BODY></HTML> Thu, 26 Jun 2014 04:10:45 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657398#M1083910 Anonymous 2014-06-26T04:10:45Z Re: How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657399#M1083911 <HTML><HEAD></HEAD><BODY><P>see the attched file </P><P></P><P>hope this helps</P></BODY></HTML> Thu, 26 Jun 2014 04:22:21 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657399#M1083911 SunilChauhan 2014-06-26T04:22:21Z Re: How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657400#M1083912 <HTML><HEAD></HEAD><BODY><P>Sunil has given you the sample file ..</P><P>Just use group by in qlikview script</P></BODY></HTML> Thu, 26 Jun 2014 04:44:13 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657400#M1083912 sujeetsingh 2014-06-26T04:44:13Z Re: How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657401#M1083913 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use group by Employee and get count(Status)&gt;1</P><P></P><P>HTH</P><P>Ravi N.</P></BODY></HTML> Thu, 26 Jun 2014 05:18:42 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657401#M1083913 Anonymous 2014-06-26T05:18:42Z Re: How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657402#M1083914 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>Dimension : Employee</P><P>Expression :</P><P>Status ----- If(Count(Distinct StatusId)&gt;1, 'Status')</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Duplicate ID</SPAN>----- If(Count(Distinct StatusId)&gt;1, Concat(StatusId, ','))</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 26 Jun 2014 05:20:55 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657402#M1083914 jagan 2014-06-26T05:20:55Z Re: How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657403#M1083915 <HTML><HEAD></HEAD><BODY><P>See the attachment hope it helps</P></BODY></HTML> Thu, 26 Jun 2014 05:29:00 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657403#M1083915 2014-06-26T05:29:00Z Re: How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657404#M1083916 <HTML><HEAD></HEAD><BODY><P>Tab:</P><P>Load * inline [</P><P>Employee&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; StatusId</P><P>Alex&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Submit&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1</P><P>Alex&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Submit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2</P><P>Alice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In progress&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B1</P><P>Jack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Submit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C1</P><P>Jack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In progress&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C2</P><P>];</P><P></P><P>Final:</P><P>NoConcatenate</P><P>Load * Where Dup like '*,*';</P><P>Load Employee,'Duplicate' As Status,Concat(StatusId,',') As Dup Resident Tab Group by Employee;</P><P></P><P>Drop table Tab;</P></BODY></HTML> Thu, 26 Jun 2014 05:30:24 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657404#M1083916 anbu1984 2014-06-26T05:30:24Z Re: Re: How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657405#M1083917 <HTML><HEAD></HEAD><BODY><P>try this</P></BODY></HTML> Thu, 26 Jun 2014 05:48:16 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657405#M1083917 2014-06-26T05:48:16Z Re: How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657406#M1083918 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><STRONG>Status:-</STRONG>if(Count(DISTINCT StatusId)&gt;1, 'duplicate',Concat(Status,','))</P><P></P><P><STRONG>Duplicate Id:-</STRONG>if( count( distinct StatusId)&gt;1, concat(StatusId,','),StatusId)</P><P></P><P>see the attachment</P></BODY></HTML> Thu, 26 Jun 2014 06:15:06 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657406#M1083918 2014-06-26T06:15:06Z Re: How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657407#M1083919 <HTML><HEAD></HEAD><BODY><P>whats wrong with my attachedment?</P></BODY></HTML> Thu, 26 Jun 2014 06:22:42 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657407#M1083919 SunilChauhan 2014-06-26T06:22:42Z Re: How to detect duplicate? https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657408#M1083920 <HTML><HEAD></HEAD><BODY><P>Tq Jagan Mohan <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 26 Jun 2014 06:28:45 GMT https://community.qlik.com/t5/QlikView/How-to-detect-duplicate/m-p/657408#M1083920 Anonymous 2014-06-26T06:28:45Z