topic Re: Sorting with special characters in QlikView https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241456#M871315 <HTML><HEAD></HEAD><BODY><P>Try sort expression like:</P><P></P><P>=rank(<STRONG>purgechar</STRONG>(YourField, '.'))</P></BODY></HTML> Tue, 29 Nov 2016 06:14:14 GMT tresB 2016-11-29T06:14:14Z Sorting with special characters https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241454#M871313 <HTML><HEAD></HEAD><BODY><P><IMG alt="Sort.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/145071_Sort.PNG" style="height: 332px; width: 620px;" /></P><P></P><P></P><P>These are two charts</P><P>In order to make the dimensions in center alignment. i have inserted dots (.) at both front and back. Because of this it couldn't able to sort </P><P>Now i want to sort it in ascending order..</P><P></P><P>Help me in finding this.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241454#M871313 Anonymous 2020-11-25T16:16:04Z Re: Sorting with special characters https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241455#M871314 <HTML><HEAD></HEAD><BODY><P>Dear Kishore,</P><P></P><P>Do you want sort the the value of <STRONG>Global Session or </STRONG> want to sort chart value.</P><P></P><P>Can you please elaborate you requirement.</P><P></P><P></P><P>Best Regards</P><P>Tripati</P></BODY></HTML> Tue, 29 Nov 2016 06:12:42 GMT https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241455#M871314 tripatirao 2016-11-29T06:12:42Z Re: Sorting with special characters https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241456#M871315 <HTML><HEAD></HEAD><BODY><P>Try sort expression like:</P><P></P><P>=rank(<STRONG>purgechar</STRONG>(YourField, '.'))</P></BODY></HTML> Tue, 29 Nov 2016 06:14:14 GMT https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241456#M871315 tresB 2016-11-29T06:14:14Z Re: Sorting with special characters https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241457#M871316 <HTML><HEAD></HEAD><BODY><P>can you please tell, how it is getting sorted with rank function?</P></BODY></HTML> Tue, 29 Nov 2016 06:19:11 GMT https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241457#M871316 Anonymous 2016-11-29T06:19:11Z Re: Sorting with special characters https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241458#M871317 <HTML><HEAD></HEAD><BODY><P>Have you tried it? Is it not working?&nbsp;&nbsp;&nbsp;&nbsp; Rank() here is ranking the text values like in <STRONG>Text Sort.</STRONG> </P></BODY></HTML> Tue, 29 Nov 2016 06:22:37 GMT https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241458#M871317 tresB 2016-11-29T06:22:37Z Re: Sorting with special characters https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241459#M871318 <HTML><HEAD></HEAD><BODY><P>yes. i tried. and its working fine.. Thanks for your help</P></BODY></HTML> Tue, 29 Nov 2016 06:24:40 GMT https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/1241459#M871318 Anonymous 2016-11-29T06:24:40Z Re: Sorting with special characters https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/2082163#M1224004 <P>Hi I have same scenario but i have extra scenario like&nbsp;</P> <P>for my column i have ._ together like&nbsp;US.IL_IDFP</P> <P>i want output like&nbsp;</P> <P>US.CBOE</P> <P>US.CME</P> <P>US.DTCC</P> <P>US.FINRA</P> <P>US.FR</P> <P>US.MGE</P> <P>US.NF</P> <P>US.OC</P> <P>US.IL_IDFP</P> <P>US-IL.IDFPf</P> <P>&nbsp;</P> Fri, 09 Jun 2023 12:18:35 GMT https://community.qlik.com/t5/QlikView/Sorting-with-special-characters/m-p/2082163#M1224004 Lucky1 2023-06-09T12:18:35Z