topic Re: SQL's List like function in QV in QlikView

SQL's List like function in QV

Fri, 03 Jan 2014 20:09:38 GMT

HI Guys,

I have a sql

SELECT TxnLineID, LIST(SerialNumberName) FROM "QBAdvancedReportGroup"."v_InvoiceLineSerial"

GROUP BY TxnLineID

It gives me comma separated list of SerialNumberName.

I want to do the same operation on QVD files without writing a for loop.

Is there any function that QV provides to do that?

REgards,

Saurabh

Nicole-Smith — Fri, 03 Jan 2014 20:10:06 GMT

concat(SerialNumberName)

and if you only want distinct values

concat(distinct SerialNumberName)

MayilVahanan — Fri, 03 Jan 2014 20:30:18 GMT

Try like this

Load TxnLineID, Concat(Distinct SerialNumberName, ',') AS SerialNumberName From Tablename

Group by TxnLineID;