Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mahendrasarkar10
Contributor
Contributor

Representing the data in comma separated format in Qlik Sense

Hi

I have a table in the below format in Qlik Sense:

mahendrasarkar10_0-1619696910688.png

This is a straight table in Qlik Sense.

However while constructing a report in NPrinting I want the values to be displayed as comma separated like: AMEU, AMGB, AMHK, AMIN, AMJP so on and so forth.

Can someone please help me with this.

Regards

Mahendra Sarkar

1 Reply
GaryGiles
Specialist
Specialist

Have you tried the concat() function?

=concat(distinct [Recipient Legal Entity Code],', ')