topic Sorting manually in QlikView https://community.qlik.com/t5/QlikView/Sorting-manually/m-p/181319#M47390 <HTML><HEAD></HEAD><BODY><P>Hi Veman</P><P>please sorting your dimension by this experiences</P><P></P><P>wildmatch(Month_Name,'A','B','C','E','F','G','H','I','J','K','L','D')</P><P></P><P>Regards</P><P>Ashish</P></BODY></HTML> Tue, 31 Aug 2010 08:42:07 GMT 2010-08-31T08:42:07Z Sorting manually https://community.qlik.com/t5/QlikView/Sorting-manually/m-p/181318#M47389 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a problem in sorting by dimension with some condition.</P><P></P><P>My dimension fields are</P><P>A</P><P>B</P><P>C</P><P>D</P><P>E</P><P>F</P><P>My requirement is I need to sort it out alphabetical order A-Z with 'D' at last row.</P><P>Waiting for help.</P><P></P></BODY></HTML> Tue, 31 Aug 2010 08:11:56 GMT https://community.qlik.com/t5/QlikView/Sorting-manually/m-p/181318#M47389 2010-08-31T08:11:56Z Sorting manually https://community.qlik.com/t5/QlikView/Sorting-manually/m-p/181319#M47390 <HTML><HEAD></HEAD><BODY><P>Hi Veman</P><P>please sorting your dimension by this experiences</P><P></P><P>wildmatch(Month_Name,'A','B','C','E','F','G','H','I','J','K','L','D')</P><P></P><P>Regards</P><P>Ashish</P></BODY></HTML> Tue, 31 Aug 2010 08:42:07 GMT https://community.qlik.com/t5/QlikView/Sorting-manually/m-p/181319#M47390 2010-08-31T08:42:07Z Sorting manually https://community.qlik.com/t5/QlikView/Sorting-manually/m-p/181320#M47391 <HTML><HEAD></HEAD><BODY><P>you can use sort by using this expression:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">if(letter = 'D', 1000000, ord(letter))</PRE></BLOCKQUOTE><BR /><BR /> <P></P><P>it means you will sort letter by their ascii values for all letters except D which will get 10000000 instead of the normal value, thus going at last row</P></BODY></HTML> Tue, 31 Aug 2010 08:51:46 GMT https://community.qlik.com/t5/QlikView/Sorting-manually/m-p/181320#M47391 2010-08-31T08:51:46Z