topic Re: duplicate & Unique in QlikView https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366857#M829857 <HTML><HEAD></HEAD><BODY><P>Hi Shivesh,</P><P></P><P>=Concat(Distinct Aggr(if(Count(Name) &gt; 1,Name),Name),', ')</P><P></P><P>returns </P><P></P><P>a, b</P><P></P><P>=Concat(Aggr(if(Count(Name) = 1,Name),Name),', ')</P><P></P><P>returns</P><P></P><P>d</P><P></P><P>Cheers</P><P></P><P>Andrew</P></BODY></HTML> Tue, 27 Jun 2017 15:47:29 GMT effinty2112 2017-06-27T15:47:29Z duplicate & Unique https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366854#M829854 <HTML><HEAD></HEAD><BODY><P>I have two columns, </P><P></P><P>Name, Salary</P><P>a,1</P><P>b,3</P><P>a,2</P><P>a,4</P><P>b,6</P><P>d,7</P><P></P><P>From these, i want below output. Not like attached</P><P></P><P>Duplicate, Unique</P><P>a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d</P><P>b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366854#M829854 shiveshsingh 2020-11-25T16:16:04Z Re: duplicate & Unique https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366855#M829855 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see Attachment.</P><P>Regards,</P><P>Antonio</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168300_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 27 Jun 2017 15:25:48 GMT https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366855#M829855 antoniotiman 2017-06-27T15:25:48Z Re: duplicate & Unique https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366856#M829856 <HTML><HEAD></HEAD><BODY><P>Try this:</P></BODY></HTML> Tue, 27 Jun 2017 15:30:57 GMT https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366856#M829856 m_woolf 2017-06-27T15:30:57Z Re: duplicate & Unique https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366857#M829857 <HTML><HEAD></HEAD><BODY><P>Hi Shivesh,</P><P></P><P>=Concat(Distinct Aggr(if(Count(Name) &gt; 1,Name),Name),', ')</P><P></P><P>returns </P><P></P><P>a, b</P><P></P><P>=Concat(Aggr(if(Count(Name) = 1,Name),Name),', ')</P><P></P><P>returns</P><P></P><P>d</P><P></P><P>Cheers</P><P></P><P>Andrew</P></BODY></HTML> Tue, 27 Jun 2017 15:47:29 GMT https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366857#M829857 effinty2112 2017-06-27T15:47:29Z Re: duplicate & Unique https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366858#M829858 <HTML><HEAD></HEAD><BODY><P>not able to open qvw file, can you show expression &amp; dimension</P></BODY></HTML> Tue, 27 Jun 2017 15:56:36 GMT https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366858#M829858 shiveshsingh 2017-06-27T15:56:36Z Re: duplicate & Unique https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366859#M829859 <HTML><HEAD></HEAD><BODY><P>Script :</P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> * <SPAN style="color: #0000ff;">Inline</SPAN> <SPAN style="color: #800000;">[<BR /> Name, Salary<BR /> a,1<BR /> b,3<BR /> a,2<BR /> a,4<BR /> b,6<BR /> d,7<BR /> ]</SPAN>; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Table (Pivot)</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Dimension :&nbsp; </SPAN><SPAN>=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN>(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN>(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN>(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Name</SPAN><SPAN>) &gt; 1,'Duplicate','Unique'),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Name</SPAN><SPAN>) </SPAN></P><P></P><P><SPAN>Expression :&nbsp; <SPAN style="color: #0000ff; font-size: 8pt;">Concat</SPAN><SPAN>(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Name</SPAN><SPAN>,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Chr</SPAN><SPAN>(10)) </SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN><SPAN>and </SPAN></SPAN></P><P><SPAN></SPAN></P><P><SPAN><SPAN><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168302_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></SPAN></P><P></P></BODY></HTML> Tue, 27 Jun 2017 16:00:27 GMT https://community.qlik.com/t5/QlikView/duplicate-Unique/m-p/1366859#M829859 antoniotiman 2017-06-27T16:00:27Z