topic Re: Sorting a dimension in QlikView https://community.qlik.com/t5/QlikView/Sorting-a-dimension/m-p/436328#M489710 <HTML><HEAD></HEAD><BODY><P>Exactly what I wanted. Thank you very much!</P></BODY></HTML> Thu, 15 Nov 2012 12:18:30 GMT 2012-11-15T12:18:30Z Sorting a dimension https://community.qlik.com/t5/QlikView/Sorting-a-dimension/m-p/436326#M489708 <HTML><HEAD></HEAD><BODY><P>I want to sort a dimension in a particular order.</P><P></P><P>F Account </P><P>C Account</P><P>R Account</P><P></P><P>It seems that none of the pre defined Sort by options allow this.</P><P></P><P>Can someone help with an expression that I can enter to sort in this order?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 15 Nov 2012 11:52:36 GMT https://community.qlik.com/t5/QlikView/Sorting-a-dimension/m-p/436326#M489708 2012-11-15T11:52:36Z Re: Sorting a dimension https://community.qlik.com/t5/QlikView/Sorting-a-dimension/m-p/436327#M489709 <HTML><HEAD></HEAD><BODY><P>Try a sort expression like</P><P></P><P>=match(DIMENSION, 'F Account','C Account','R Account')</P></BODY></HTML> Thu, 15 Nov 2012 11:54:36 GMT https://community.qlik.com/t5/QlikView/Sorting-a-dimension/m-p/436327#M489709 swuehl 2012-11-15T11:54:36Z Re: Sorting a dimension https://community.qlik.com/t5/QlikView/Sorting-a-dimension/m-p/436328#M489710 <HTML><HEAD></HEAD><BODY><P>Exactly what I wanted. Thank you very much!</P></BODY></HTML> Thu, 15 Nov 2012 12:18:30 GMT https://community.qlik.com/t5/QlikView/Sorting-a-dimension/m-p/436328#M489710 2012-11-15T12:18:30Z