Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL's List like function in QV

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

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

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

Group by TxnLineID;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
Nicole-Smith

concat(SerialNumberName)

and if you only want distinct values

concat(distinct SerialNumberName)

MayilVahanan

Hi

Try like this

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

Group by TxnLineID;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.