topic Re: How to add concatenated list box fied in QlikView

How to add concatenated list box fied

Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have a list box where I need to add a concatenated filed. At the moment its allowing me to specify only one filed ?

I understand that I can change the script SQL and add a new field. Rather than doing that way is there an easy workaround ?

Thanks in advance

Buminda

sushil353 — Fri, 02 Dec 2016 03:26:19 GMT

Hi,

in the Field drop down goto > Expression and there you can write =Field1&Field2

HTH

Sushil

Anonymous — Fri, 02 Dec 2016 03:33:10 GMT

Hi,

in expression tab you can concatenate the fields with this &(symbol).

like....filed1 & filed2

and you can name it as single filed in title.

Fri, 02 Dec 2016 03:57:36 GMT

Thanks Sushil, this worked.

Fri, 02 Dec 2016 03:58:09 GMT

Thanks , yes this helped me.