topic How to concate single Colum values in QlikView

How to concate single Colum values

Wed, 22 Dec 2010 15:09:14 GMT

this is input

i want output like that o/p:

please let me know do this output , can u provide the script?

Regards,

Satya

pover — Wed, 22 Dec 2010 15:17:08 GMT

Satya,

Use the concat() function as an expression in your chart.

concat(Location,', ')

Regards.

Wed, 22 Dec 2010 15:29:46 GMT

Hi,

really great, now it is working thanks for your inputs.

Regards,

Satya

martinpohl — Wed, 22 Dec 2010 15:31:04 GMT

try this:

load

[CUSTOMER ID],

concate (Location,', ') as ConcatLocation

resident loadedtable;

Regards