topic Re: Names in text box in QlikView

Names in text box

Tue, 24 Mar 2015 15:41:40 GMT

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 — Tue, 24 Mar 2015 15:42:35 GMT

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

giakoum — Tue, 24 Mar 2015 15:43:20 GMT

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

But only shows only one value, not multiple

Tue, 24 Mar 2015 15:44:03 GMT

Thanks thanks!

awhitfield — Wed, 25 Mar 2015 10:39:39 GMT

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

Wed, 25 Mar 2015 10:44:02 GMT

Hi Andy,

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

Thanks.