Solved: Concat using Distinct - Qlik Community

T_Qlik · ‎2024-04-18

Replace (Concat(distinct KPI,''),',', ' * ')

MayilVahanan · ‎2024-04-18

Hi

Try like below

Load *, trim(SubField(KPI,',')) as KPI1 Inline
[
KPI
Sales, Customer
Sales, Source
](delimiter is '|');

Exp:

=Concat(distinct KPI1,'*')

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

MayilVahanan · ‎2024-04-18

Hi

Try like below

Load *, trim(SubField(KPI,',')) as KPI1 Inline
[
KPI
Sales, Customer
Sales, Source
](delimiter is '|');

Exp:

=Concat(distinct KPI1,'*')

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

T_Qlik · ‎2024-04-18

Thanks Man!

Concat using Distinct