https://community.qlik.com/t5/QlikView/concat-without-duplicates/m-p/1597756#M738388 <P>Hy!</P><P>&nbsp;</P><P>I have following table:</P><TABLE border="1"><TBODY><TR><TD>Tour</TD><TD>OrderNb.</TD></TR><TR><TD>1234567</TD><TD>123</TD></TR><TR><TD>1234567</TD><TD>123</TD></TR><TR><TD>1234567</TD><TD>789</TD></TR><TR><TD>1234567</TD><TD>789</TD></TR><TR><TD>9876543</TD><TD>456</TD></TR><TR><TD>9876543</TD><TD>369</TD></TR><TR><TD>9876543</TD><TD>456</TD></TR><TR><TD>9876543</TD><TD>369</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Now I want to summarize each tour on one line.</P><P>BUT concat OrderNb. <STRONG>without duplicates</STRONG> for a better view:</P><P>Like:</P><TABLE border="1"><TBODY><TR><TD>Tour</TD><TD>OrderNb.&nbsp;</TD></TR><TR><TD>1234567</TD><TD>123; 789</TD></TR><TR><TD>9876543</TD><TD>456; 369</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Do you have any idea?</P><P>Thank you!</P> Wed, 25 Nov 2020 16:16:04 GMT Keyuser 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/concat-without-duplicates/m-p/1597756#M738388 <P>Hy!</P><P>&nbsp;</P><P>I have following table:</P><TABLE border="1"><TBODY><TR><TD>Tour</TD><TD>OrderNb.</TD></TR><TR><TD>1234567</TD><TD>123</TD></TR><TR><TD>1234567</TD><TD>123</TD></TR><TR><TD>1234567</TD><TD>789</TD></TR><TR><TD>1234567</TD><TD>789</TD></TR><TR><TD>9876543</TD><TD>456</TD></TR><TR><TD>9876543</TD><TD>369</TD></TR><TR><TD>9876543</TD><TD>456</TD></TR><TR><TD>9876543</TD><TD>369</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Now I want to summarize each tour on one line.</P><P>BUT concat OrderNb. <STRONG>without duplicates</STRONG> for a better view:</P><P>Like:</P><TABLE border="1"><TBODY><TR><TD>Tour</TD><TD>OrderNb.&nbsp;</TD></TR><TR><TD>1234567</TD><TD>123; 789</TD></TR><TR><TD>9876543</TD><TD>456; 369</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Do you have any idea?</P><P>Thank you!</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/concat-without-duplicates/m-p/1597756#M738388 Keyuser 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/concat-without-duplicates/m-p/1597764#M738389 <P>Hi</P><P>&nbsp;</P><P>Try using the following</P><P>&nbsp;</P><P>Concat(Distinct OrderNb. , '; ')</P><P>&nbsp;</P><P>Regards</P><P>Adrian</P> Mon, 01 Jul 2019 15:54:44 GMT https://community.qlik.com/t5/QlikView/concat-without-duplicates/m-p/1597764#M738389 atoz1158 2019-07-01T15:54:44Z https://community.qlik.com/t5/QlikView/concat-without-duplicates/m-p/1597766#M738390 <P>Ouch, you're right.</P><P>Sometimes the simplest solution is the hardest&nbsp;<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span></P> Mon, 01 Jul 2019 16:02:09 GMT https://community.qlik.com/t5/QlikView/concat-without-duplicates/m-p/1597766#M738390 Keyuser 2019-07-01T16:02:09Z