topic Re: Concatenating Columns in QlikView

Concatenating Columns

Wed, 03 Oct 2012 06:27:03 GMT

Hi ,

How to concatenate 2 (colA & ColB) columns in qlikview List box control ?

Thanks

RAhul

Re: Concatenating Columns

Wed, 03 Oct 2012 06:45:01 GMT

Good Day,

Can you show some example.

Regards

Re: Concatenating Columns

Anonymous — Wed, 03 Oct 2012 07:21:38 GMT

Hi everyone,

In List box properties, select <Expression> in Field list (General Tab).

It's recomended to create your concatenated field into the script.

Regards

Re: Concatenating Columns

Wed, 03 Oct 2012 07:32:55 GMT

Hi,

Its better to do it in your script

but if you can't, you can use concat() function

See attached file for sample.

Regards,

Alex

Re: Concatenating Columns

jonathandienst — Wed, 03 Oct 2012 08:03:00 GMT

Actually it does not need to be as complicated as that. Set the listbox to expression and simply use something like

=Field1 & ' ' & Field2

Hope that helps

Jonathan

Re: Concatenating Columns

Wed, 03 Oct 2012 08:14:40 GMT

Hi,

I suggested concat() function because Field1 &' '& Field2 gives me additional row.

Thanks for the info though

Regards,

Alex

Re: Concatenating Columns

jonathandienst — Wed, 03 Oct 2012 09:00:39 GMT

Alex

I changed your qvw to =Field1 & ' ' & Field2 and I did not get an extra row. (using QV10 SR5).

Regards

Jonathan

Re: Concatenating Columns

Wed, 03 Oct 2012 09:59:47 GMT

Hi,

Im using QV11, it might be because of QV version.

Regards,

Alex

Re: Concatenating Columns

Wed, 03 Oct 2012 10:19:59 GMT

Hi guys,

i have attached the QVW file for referance. so there are 2 list boxes

Qx & Year. So i want to concatenate both columns in such away output shud display like 'YearQtr' listbox. how to write listbox expression or in script?

Thanks

Rahul

Re: Concatenating Columns

Wed, 03 Oct 2012 10:23:43 GMT

Hi,

Try on your script

Load

ColumnA,

ColumnB,

ColumnA&' '&ColumnB as ColumnC

From C////

Regards.

Re: Concatenating Columns

Anonymous — Wed, 03 Oct 2012 12:01:32 GMT

Alexis,

It seems to be a bug à QV11 SR1.

Take a look to the release QV11 SR2 note:

44373 Using a Calculated dimension to concatenate values in a ListBox object results in an additional

value(s) appearing.

Regards