Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try sorting by aggr(sum(Sales2011),User). See attached example.
Try sorting by aggr(sum(Sales2011),User). See attached example.