topic Re: Sort Data concatenated? in QlikView https://community.qlik.com/t5/QlikView/Sort-Data-concatenated/m-p/432814#M161297 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>Have you tried the solution ?</P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/message/262039#262039" title="http://community.qlik.com/message/262039#262039">http://community.qlik.com/message/262039#262039</A><A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/message/262039#262039" title="http://community.qlik.com/message/262039#262039">Re: Ordenar valores Concatenados?</A></P></BODY></HTML> Mon, 24 Sep 2012 06:59:55 GMT whiteline 2012-09-24T06:59:55Z Sort Data concatenated? https://community.qlik.com/t5/QlikView/Sort-Data-concatenated/m-p/432813#M161296 <HTML><HEAD></HEAD><BODY><P>I have 2 tables.</P><P></P><P>table 1</P><P></P><P>Record ID</P><P>1 A</P><P>2 B</P><P>3 C</P><P>4 D</P><P></P><P></P><P>Table 2:</P><P>Field1 IDRelacion</P><P>1 AAA</P><P>1 BBB</P><P>1 CCC</P><P>1 DDD</P><P>2 EEA</P><P></P><P></P><P></P><P>I turn them as follows:</P><P>ID &amp; chr (10) &amp; Registration &amp; chr (10) &amp; concat (field1, chr (10)</P><P>1</P><P>A</P><P>AAA</P><P>BBB</P><P>CCC</P><P>DDD</P><P></P><P></P><P></P><P></P><P>But I nesecito that those letters are in order so descendeten:</P><P>1</P><P>A</P><P>EEA</P><P>DDD</P><P>CCC</P><P>BBB</P><P>AAA</P></BODY></HTML> Mon, 24 Sep 2012 03:07:43 GMT https://community.qlik.com/t5/QlikView/Sort-Data-concatenated/m-p/432813#M161296 2012-09-24T03:07:43Z Re: Sort Data concatenated? https://community.qlik.com/t5/QlikView/Sort-Data-concatenated/m-p/432814#M161297 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>Have you tried the solution ?</P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/message/262039#262039" title="http://community.qlik.com/message/262039#262039">http://community.qlik.com/message/262039#262039</A><A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/message/262039#262039" title="http://community.qlik.com/message/262039#262039">Re: Ordenar valores Concatenados?</A></P></BODY></HTML> Mon, 24 Sep 2012 06:59:55 GMT https://community.qlik.com/t5/QlikView/Sort-Data-concatenated/m-p/432814#M161297 whiteline 2012-09-24T06:59:55Z