topic Not the same names in the text box in QlikView https://community.qlik.com/t5/QlikView/Not-the-same-names-in-the-text-box/m-p/787677#M1019208 <HTML><HEAD></HEAD><BODY><P>Here asked I a question:</P><P></P><P>@<A _jive_internal="true" class="title" href="https://community.qlik.com/thread/157401"><STRONG style="color: #3778c7;">Names in text box</STRONG></A></P><P></P><P>Now, I have a sort of. Some names have 3 numbers and than there are 3 the same names in the text box.</P><P></P><P>Is there an option to say that it is impossible to have the same names in the text box?</P></BODY></HTML> Wed, 25 Mar 2015 10:30:57 GMT 2015-03-25T10:30:57Z Not the same names in the text box https://community.qlik.com/t5/QlikView/Not-the-same-names-in-the-text-box/m-p/787677#M1019208 <HTML><HEAD></HEAD><BODY><P>Here asked I a question:</P><P></P><P>@<A _jive_internal="true" class="title" href="https://community.qlik.com/thread/157401"><STRONG style="color: #3778c7;">Names in text box</STRONG></A></P><P></P><P>Now, I have a sort of. Some names have 3 numbers and than there are 3 the same names in the text box.</P><P></P><P>Is there an option to say that it is impossible to have the same names in the text box?</P></BODY></HTML> Wed, 25 Mar 2015 10:30:57 GMT https://community.qlik.com/t5/QlikView/Not-the-same-names-in-the-text-box/m-p/787677#M1019208 2015-03-25T10:30:57Z Re: Not the same names in the text box https://community.qlik.com/t5/QlikView/Not-the-same-names-in-the-text-box/m-p/787678#M1019209 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Sorry pasted this on the wrong issue before, you need to use distinct in the your expression</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Concat</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Distinct</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Name</SPAN><SPAN style="font-size: 8pt;">&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">CHR</SPAN><SPAN style="font-size: 8pt;">(13))) </SPAN></P><P></P><P></P><P>andy</P></BODY></HTML> Wed, 25 Mar 2015 10:50:08 GMT https://community.qlik.com/t5/QlikView/Not-the-same-names-in-the-text-box/m-p/787678#M1019209 awhitfield 2015-03-25T10:50:08Z Re: Not the same names in the text box https://community.qlik.com/t5/QlikView/Not-the-same-names-in-the-text-box/m-p/787679#M1019210 <HTML><HEAD></HEAD><BODY><P>Thanks Andy, it is indeed another formula .</P><P>Sorry.</P><P></P><P>And it is correct~! </P></BODY></HTML> Wed, 25 Mar 2015 11:07:45 GMT https://community.qlik.com/t5/QlikView/Not-the-same-names-in-the-text-box/m-p/787679#M1019210 2015-03-25T11:07:45Z