topic Re: Sort the Concat function with 2 dimension in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Sort-the-Concat-function-with-2-dimension/m-p/1347965#M17430 <HTML><HEAD></HEAD><BODY><P>Is Rowno a field name? Or do you mean RowNo()?</P><P></P><P>It would be much easier to help you if you provided more details. Its hard to diagnose and fix "incorrect result". The best would be a small qvw file containing sample data and the chart/table that illustrates the problem, along with the output you want.</P></BODY></HTML> Fri, 23 Jun 2017 10:26:04 GMT jonathandienst 2017-06-23T10:26:04Z Sort the Concat function with 2 dimension https://community.qlik.com/t5/Qlik-NPrinting/Sort-the-Concat-function-with-2-dimension/m-p/1347964#M17429 <HTML><HEAD></HEAD><BODY><P>As we have sort the values of concat function with 1 dimension</P><P><STRONG><EM style=": ; color: #808080; font-size: 8pt;">Concat(DISTINCT RawDim, '|',Rowno)</EM></STRONG></P><P><STRONG></STRONG></P><P><STRONG><EM style=": ; color: #808080; font-size: 8pt;"><BR /></EM></STRONG></P><P><STRONG><EM style=": ; color: #808080; font-size: 8pt;">Can we this using two dimension</EM></STRONG></P><P><STRONG><EM style=": ; color: #808080; font-size: 8pt;"><BR /></EM></STRONG></P><P><STRONG><EM style=": ; color: #808080; font-size: 8pt;">I tried&nbsp; this </EM></STRONG></P><P><STRONG></STRONG></P><P><STRONG><EM style=": ; color: #808080; font-size: 8pt;"><STRONG><EM>Concat(DISTINCT RawDim, '|',Rowno)</EM></STRONG></EM></STRONG></P><P><STRONG></STRONG></P><P><STRONG><EM style=": ; color: #808080; font-size: 8pt;">but this gives incorrect result</EM></STRONG></P></BODY></HTML> Fri, 23 Jun 2017 10:12:10 GMT https://community.qlik.com/t5/Qlik-NPrinting/Sort-the-Concat-function-with-2-dimension/m-p/1347964#M17429 Anonymous 2017-06-23T10:12:10Z Re: Sort the Concat function with 2 dimension https://community.qlik.com/t5/Qlik-NPrinting/Sort-the-Concat-function-with-2-dimension/m-p/1347965#M17430 <HTML><HEAD></HEAD><BODY><P>Is Rowno a field name? Or do you mean RowNo()?</P><P></P><P>It would be much easier to help you if you provided more details. Its hard to diagnose and fix "incorrect result". The best would be a small qvw file containing sample data and the chart/table that illustrates the problem, along with the output you want.</P></BODY></HTML> Fri, 23 Jun 2017 10:26:04 GMT https://community.qlik.com/t5/Qlik-NPrinting/Sort-the-Concat-function-with-2-dimension/m-p/1347965#M17430 jonathandienst 2017-06-23T10:26:04Z Re: Sort the Concat function with 2 dimension https://community.qlik.com/t5/Qlik-NPrinting/Sort-the-Concat-function-with-2-dimension/m-p/1347966#M17431 <HTML><HEAD></HEAD><BODY><P>You can actually write an expression for sort order, like:</P><P></P><P>Concat( Distinct SalesMan, '|' , Year*100+Num(Month))</P></BODY></HTML> Fri, 23 Jun 2017 10:26:05 GMT https://community.qlik.com/t5/Qlik-NPrinting/Sort-the-Concat-function-with-2-dimension/m-p/1347966#M17431 tresB 2017-06-23T10:26:05Z