topic Re: Sort a list in text object by Dimension in QlikView https://community.qlik.com/t5/QlikView/Sort-a-list-in-text-object-by-Dimension/m-p/584426#M546779 <HTML><HEAD></HEAD><BODY><P>Not sure how you are displaying the Field in the text box. I would assume you are concatenating the field values. The concat function has a built in sorting mechanism if you use the third parameter like:</P><P></P><P>concat(Company, ',', [Company sequence])</P><P></P><P>or </P><P></P><P>concat(Company, ',', -[Company sequence])</P><P></P><P>Depends if you want ascending or descending.</P><P></P><P>Hope this helps!</P></BODY></HTML> Mon, 17 Mar 2014 16:11:09 GMT jerem1234 2014-03-17T16:11:09Z Sort a list in text object by Dimension https://community.qlik.com/t5/QlikView/Sort-a-list-in-text-object-by-Dimension/m-p/584425#M546778 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a dimension that i sort in my graphics with another dimension. It allows to give specific order to the dimension. But i have to show this dimension in a report, so in a text box, and i don't find a way to sort it the like the dimension.</P><P><IMG alt="Commencer une nouvelle discussion Qlik Community - Google Chrome.jpg" class="jive-image" src="/legacyfs/online/55167_Commencer une nouvelle discussion Qlik Community - Google Chrome.jpg" style="width: 620px; height: 339px;" /></P><P></P><P>It should exist a formula like sort(dimension, field)... or i don't know.</P><P></P><P>Thanks for the help !</P></BODY></HTML> Mon, 17 Mar 2014 16:06:34 GMT https://community.qlik.com/t5/QlikView/Sort-a-list-in-text-object-by-Dimension/m-p/584425#M546778 2014-03-17T16:06:34Z Re: Sort a list in text object by Dimension https://community.qlik.com/t5/QlikView/Sort-a-list-in-text-object-by-Dimension/m-p/584426#M546779 <HTML><HEAD></HEAD><BODY><P>Not sure how you are displaying the Field in the text box. I would assume you are concatenating the field values. The concat function has a built in sorting mechanism if you use the third parameter like:</P><P></P><P>concat(Company, ',', [Company sequence])</P><P></P><P>or </P><P></P><P>concat(Company, ',', -[Company sequence])</P><P></P><P>Depends if you want ascending or descending.</P><P></P><P>Hope this helps!</P></BODY></HTML> Mon, 17 Mar 2014 16:11:09 GMT https://community.qlik.com/t5/QlikView/Sort-a-list-in-text-object-by-Dimension/m-p/584426#M546779 jerem1234 2014-03-17T16:11:09Z Re: Sort a list in text object by Dimension https://community.qlik.com/t5/QlikView/Sort-a-list-in-text-object-by-Dimension/m-p/584427#M546780 <HTML><HEAD></HEAD><BODY><P>Damn that was quick <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /> !</P><P></P><P>Thanks a lot !</P></BODY></HTML> Mon, 17 Mar 2014 16:13:24 GMT https://community.qlik.com/t5/QlikView/Sort-a-list-in-text-object-by-Dimension/m-p/584427#M546780 2014-03-17T16:13:24Z