Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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],', ')