Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Concat and sort by a column

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.

1 Solution

Accepted Solutions

Re: Concat and sort by a column

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


talk is cheap, supply exceeds demand
1 Reply

Re: Concat and sort by a column

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


talk is cheap, supply exceeds demand
Community Browser