Concat and sort by a column

[#1]

Hello,

How to sort the concated data in an expression by a column in the same straight table ?

Stated in the QlikTech Technical Brief - The CONCAT() Function:

When using a simple concat, you have the option to add a
sort weight to the function to order the string values by a column of your
choice. In the example below,  the date column is used to sort the
values…..

=CONCAT(MyColumn, ',', Date)

See the added example, it`s not working in the way I like to use it.

[Gysbert_Wassenaar · Accepted solution]

Try sorting by aggr(sum(Sales2011),User). See attached example.