Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

QlikView App Dev

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details

Who Me Too'd this solution

MK_QSL
MVP
MVP

Try this

I considered both field names Table A and Table B.

You can change accordingly.

=Concat(Distinct Aggr(IF(SubStringCount(Concat(DISTINCT [Table A],', '),[Table B])=0,[Table B]),[Table B]),', ')

View solution in original post

Who Me Too'd this solution