Solved: Concat using Distinct - Qlik Community

Tarun_Qlik

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

MayilVahanan

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

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.

Tarun_Qlik

Thanks Man!

Concat using Distinct