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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

sorting the result of a concat function

Hi,

is it possible to sort the result of a concat function by an expression?

Thank you in advance,

Larisa

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Sure:

=concat(field, delimiter, sort)

View solution in original post

5 Replies
sunny_talwar

Can you give an example of what you are trying to accomplish?

Anonymous
Not applicable
Author

Sure:

=concat(field, delimiter, sort)

Anonymous
Not applicable
Author

Ок, thank you!

Is it possible to count the number of values in the string which is the result of a concat function?

Thank you in advance,

Larisa

Anonymous
Not applicable
Author

If I got the question right:

=concat(field, delimiter, sort)

returns the number of values which can be calculated using

=count(field)

If you use "distinct" in concat() - use it in count() too.

Anonymous
Not applicable
Author

Thank you!