Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Keyuser
Contributor
Contributor

concat without duplicates

Hy!

 

I have following table:

TourOrderNb.
1234567123
1234567123
1234567789
1234567789
9876543456
9876543369
9876543456
9876543369

 

Now I want to summarize each tour on one line.

BUT concat OrderNb. without duplicates for a better view:

Like:

TourOrderNb. 
1234567123; 789
9876543456; 369

 

Do you have any idea?

Thank you!

1 Solution

Accepted Solutions
atoz1158
Creator II
Creator II

Hi

 

Try using the following

 

Concat(Distinct OrderNb. , '; ')

 

Regards

Adrian

View solution in original post

2 Replies
atoz1158
Creator II
Creator II

Hi

 

Try using the following

 

Concat(Distinct OrderNb. , '; ')

 

Regards

Adrian

Keyuser
Contributor
Contributor
Author

Ouch, you're right.

Sometimes the simplest solution is the hardest 😁