Names in text box

[#1]

If I selected some names of my customers in the list, I want these in a separate text box.

Now I made a text box, and the expession =Name

And if I selected one name it is correct. But if I selected more than one, it failed. \

What is my fault?

[giakoum]

you need to use =concat(Name, ',')

[giakoum]

if you use only Name, QlikView automatically assumes the function is only (only(name))

But only shows only one value, not multiple

[#4]

Thanks thanks!

[awhitfield · Accepted solution]

Hi Lieko234,

you could try

=Concat(Distinct(Name&CHR(13)))

This will give you a single record for each name on a separate line.

Andy

[#6]

Hi Andy,

I know, but it is also correct with CHR(10).

Thanks.