topic Re: sorting the result of a concat function in QlikView https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836432#M1007456 <HTML><HEAD></HEAD><BODY><P>Can you give an example of what you are trying to accomplish?</P></BODY></HTML> Fri, 22 May 2015 16:55:58 GMT sunny_talwar 2015-05-22T16:55:58Z sorting the result of a concat function https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836431#M1007455 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>is it possible to sort the result of a concat function by an expression?</P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Fri, 22 May 2015 16:47:11 GMT https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836431#M1007455 Anonymous 2015-05-22T16:47:11Z Re: sorting the result of a concat function https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836432#M1007456 <HTML><HEAD></HEAD><BODY><P>Can you give an example of what you are trying to accomplish?</P></BODY></HTML> Fri, 22 May 2015 16:55:58 GMT https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836432#M1007456 sunny_talwar 2015-05-22T16:55:58Z Re: sorting the result of a concat function https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836433#M1007457 <HTML><HEAD></HEAD><BODY><P>Sure:</P><P>=concat(field, delimiter, <STRONG>sort</STRONG>)</P></BODY></HTML> Fri, 22 May 2015 16:57:01 GMT https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836433#M1007457 Anonymous 2015-05-22T16:57:01Z Re: sorting the result of a concat function https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836434#M1007458 <HTML><HEAD></HEAD><BODY><P>Ок, thank you!</P><P>Is it possible to count the number of values in the string which is the result of a concat function?</P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Fri, 22 May 2015 18:04:22 GMT https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836434#M1007458 Anonymous 2015-05-22T18:04:22Z Re: sorting the result of a concat function https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836435#M1007459 <HTML><HEAD></HEAD><BODY><P>If I got the question right:</P><P>=concat(field, delimiter, sort)</P><P>returns the number of values which can be calculated using</P><P>=count(field)</P><P></P><P>If you use "distinct" in concat() - use it in count() too.</P></BODY></HTML> Fri, 22 May 2015 18:09:02 GMT https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836435#M1007459 Anonymous 2015-05-22T18:09:02Z Re: sorting the result of a concat function https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836436#M1007460 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Fri, 22 May 2015 18:15:11 GMT https://community.qlik.com/t5/QlikView/sorting-the-result-of-a-concat-function/m-p/836436#M1007460 Anonymous 2015-05-22T18:15:11Z