Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
How to concatenate 2 (colA & ColB) columns in qlikview List box control ?
Thanks
RAhul
Good Day,
Can you show some example.
Regards
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
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
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
Hi,
I suggested concat() function because Field1 &' '& Field2 gives me additional row.
Thanks for the info though
Regards,
Alex
Alex
I changed your qvw to =Field1 & ' ' & Field2 and I did not get an extra row. (using QV10 SR5).
Regards
Jonathan
Hi,
Im using QV11, it might be because of QV version.
Regards,
Alex
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
Hi,
Try on your script
Load
ColumnA,
ColumnB,
ColumnA&' '&ColumnB as ColumnC
From C////
Regards.