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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
T_Qlik
Contributor III
Contributor III
‎2024-04-18 06:02 AM

Concat using Distinct

Tarun_Qlik_0-1713434470389.png

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

Labels (3)
Labels
1,201 Views
1 Solution

Accepted Solutions
MayilVahanan
MVP
MVP
‎2024-04-18 06:10 AM

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.

View solution in original post

1,195 Views
0 Likes
2 Replies
MayilVahanan
MVP
MVP
‎2024-04-18 06:10 AM

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.
1,196 Views
0 Likes
T_Qlik
Contributor III
Contributor III
‎2024-04-18 07:52 AM
Author

Thanks Man!

1,165 Views
0 Likes