Concatenating Columns

[#1]

Hi ,

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

Thanks

RAhul

[#2]

Good Day,

     Can you show some example.

Regards

[Anonymous]

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

[#4]

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

[jonathandienst]

Hi

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

[#6]

Hi,

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

Thanks for the info though

Regards,

Alex

[jonathandienst]

Alex

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

Regards

Jonathan

[#8]

Hi,

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

Regards,

Alex

[#9]

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

[#10]

Hi,

     Try on your script

     Load

     ColumnA,

     ColumnB,

     ColumnA&' '&ColumnB as ColumnC

     From C////

Regards.