topic Re: Concat and sort by a column in QlikView https://community.qlik.com/t5/QlikView/Concat-and-sort-by-a-column/m-p/508363#M483597 <HTML><HEAD></HEAD><BODY><P>Try sorting by aggr(sum(Sales2011),User). See attached example.</P></BODY></HTML> Tue, 25 Jun 2013 18:27:44 GMT Gysbert_Wassenaar 2013-06-25T18:27:44Z Concat and sort by a column https://community.qlik.com/t5/QlikView/Concat-and-sort-by-a-column/m-p/508362#M483596 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>How to sort the concated data in an expression by a column in the same straight table ?</P><P></P><P>Stated in the QlikTech Technical Brief - <SPAN lang="EN-US">The CONCAT() Function:</SPAN> </P><P style="margin: 0 0 0 4.3pt;"><SPAN lang="EN-GB" style="font-family: &amp;quot;Arial&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt;">When using a simple concat, you have the option to add a<BR />sort weight to the function to order the string values by a column of your<BR />choice. In the example below,&nbsp; the date column is used to sort the<BR />values…..</SPAN></P><P> <SPAN lang="EN-GB" style="font-family: &amp;quot;Arial&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt;">=CONCAT(MyColumn, ',', Date)</SPAN></P><P></P><P>See the added example, it`s not working in the way I like to use it. </P></BODY></HTML> Tue, 25 Jun 2013 18:23:14 GMT https://community.qlik.com/t5/QlikView/Concat-and-sort-by-a-column/m-p/508362#M483596 2013-06-25T18:23:14Z Re: Concat and sort by a column https://community.qlik.com/t5/QlikView/Concat-and-sort-by-a-column/m-p/508363#M483597 <HTML><HEAD></HEAD><BODY><P>Try sorting by aggr(sum(Sales2011),User). See attached example.</P></BODY></HTML> Tue, 25 Jun 2013 18:27:44 GMT https://community.qlik.com/t5/QlikView/Concat-and-sort-by-a-column/m-p/508363#M483597 Gysbert_Wassenaar 2013-06-25T18:27:44Z