sorting the result of a concat function

[Anonymous]

Hi,

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

Thank you in advance,

Larisa

[sunny_talwar]

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

[Anonymous · Accepted solution]

Sure:

=concat(field, delimiter, sort)

[Anonymous]

Ок, 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]

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]

Thank you!