Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
you need to use =concat(Name, ',')
if you use only Name, QlikView automatically assumes the function is only (only(name))
But only shows only one value, not multiple
Thanks thanks!
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
Hi Andy,
I know, but it is also correct with CHR(10).
Thanks.