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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatenate strings for distinct values

Good morning, I have the following situation:


I have a code in column A and a column B with a field tha contains NOTES.
The field A may be repeated on multiple lines with different values of NOTES.

I need to have for each distinct value of the field A concatenation NOTES present in field B.


How can I do this?

Thanks

11 Replies
anbu1984
Master III
Master III

aggr (Concat (DISTINCT NONOTA, '',RIGA), NOKEY)
Not applicable
Author

Thanks Anbu, it works great !