topic Sorting by an Expression in QlikView https://community.qlik.com/t5/QlikView/Sorting-by-an-Expression/m-p/542408#M1128344 <HTML><HEAD></HEAD><BODY><P>I have a pie chart with two dimensions and an expression which is the total of the two dimensions.&nbsp; I want to sort the expression in descending order but I'm unable to do so.&nbsp; Is there a way to sort by an expression when you have dimensions?&nbsp; I'm thinking I have to include the sort option within the expression as you would when writing a SQL statement (i.e. ORDER BY column_name DESC).</P></BODY></HTML> Fri, 06 Dec 2013 16:55:18 GMT 2013-12-06T16:55:18Z Sorting by an Expression https://community.qlik.com/t5/QlikView/Sorting-by-an-Expression/m-p/542408#M1128344 <HTML><HEAD></HEAD><BODY><P>I have a pie chart with two dimensions and an expression which is the total of the two dimensions.&nbsp; I want to sort the expression in descending order but I'm unable to do so.&nbsp; Is there a way to sort by an expression when you have dimensions?&nbsp; I'm thinking I have to include the sort option within the expression as you would when writing a SQL statement (i.e. ORDER BY column_name DESC).</P></BODY></HTML> Fri, 06 Dec 2013 16:55:18 GMT https://community.qlik.com/t5/QlikView/Sorting-by-an-Expression/m-p/542408#M1128344 2013-12-06T16:55:18Z Re: Sorting by an Expression https://community.qlik.com/t5/QlikView/Sorting-by-an-Expression/m-p/542409#M1128345 <HTML><HEAD></HEAD><BODY><P>On the Sort tab of the properties window you should be able to choose the option Expression and then enter an expression. The results of the expression will be used for the sort order.</P></BODY></HTML> Fri, 06 Dec 2013 17:12:04 GMT https://community.qlik.com/t5/QlikView/Sorting-by-an-Expression/m-p/542409#M1128345 Gysbert_Wassenaar 2013-12-06T17:12:04Z Re: Sorting by an Expression https://community.qlik.com/t5/QlikView/Sorting-by-an-Expression/m-p/542410#M1128346 <HTML><HEAD></HEAD><BODY><P>That worked!&nbsp; Thank you Gysbert!</P></BODY></HTML> Fri, 06 Dec 2013 17:40:08 GMT https://community.qlik.com/t5/QlikView/Sorting-by-an-Expression/m-p/542410#M1128346 2013-12-06T17:40:08Z