Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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

View solution in original post

Keyuser
Contributor
Contributor
Author

Ouch, you're right.

Sometimes the simplest solution is the hardest 😁