topic Re: Straight table for multiple metrics sorting in QlikView https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995639#M955774 <HTML><HEAD></HEAD><BODY><P>May be try using the expression you are using for Value Dispensed for all your dimension's sorting expression. </P></BODY></HTML> Fri, 13 Nov 2015 19:24:11 GMT sunny_talwar 2015-11-13T19:24:11Z Straight table for multiple metrics sorting https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995638#M955773 <HTML><HEAD></HEAD><BODY><P>I have a straight table with the following multiple metrics:</P><P></P><P><IMG alt="Screen Shot 2015-11-13 at 21.16.33.png" class="jive-image image-1" src="/legacyfs/online/105481_Screen Shot 2015-11-13 at 21.16.33.png" style="height: 183px; width: 620px;" /></P><P>I want the straight table sorted by 'Value Dispensed' with highest value at the top and i have tried this with the sort option and selecting descending but not getting what i want.&nbsp; How can i accomplish this?</P><P></P><P>Regards.</P></BODY></HTML> Fri, 13 Nov 2015 19:22:39 GMT https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995638#M955773 Anonymous 2015-11-13T19:22:39Z Re: Straight table for multiple metrics sorting https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995639#M955774 <HTML><HEAD></HEAD><BODY><P>May be try using the expression you are using for Value Dispensed for all your dimension's sorting expression. </P></BODY></HTML> Fri, 13 Nov 2015 19:24:11 GMT https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995639#M955774 sunny_talwar 2015-11-13T19:24:11Z Re: Straight table for multiple metrics sorting https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995640#M955775 <HTML><HEAD></HEAD><BODY><P>Your chart seems to be sorted correctly in ascending sort order.</P><P>When you are saying 'not getting what I want' when you change order to descending, what do you actually get?</P><P></P><P>What sort options have you chosen on sort tab? Could you post a screenshot or better, a small sample QVW that demonstrates your issue?</P></BODY></HTML> Fri, 13 Nov 2015 19:30:00 GMT https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995640#M955775 swuehl 2015-11-13T19:30:00Z Re: Straight table for multiple metrics sorting https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995641#M955776 <HTML><HEAD></HEAD><BODY><P>Swuehl</P><P></P><P>Thank you very much.&nbsp; Please find attached the application.&nbsp; The sorting i want is exactly the opposite of what is currently shown in the app.</P><P></P><P>Regards.</P></BODY></HTML> Fri, 13 Nov 2015 20:09:25 GMT https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995641#M955776 Anonymous 2015-11-13T20:09:25Z Re: Straight table for multiple metrics sorting https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995642#M955777 <HTML><HEAD></HEAD><BODY><P>Sunny thank you for your response</P></BODY></HTML> Fri, 13 Nov 2015 20:10:26 GMT https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995642#M955777 Anonymous 2015-11-13T20:10:26Z Re: Straight table for multiple metrics sorting https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995643#M955778 <HTML><HEAD></HEAD><BODY><P>Maybe like attached.</P><P></P><P>In addition to the sort order, I've changed the setting in dimension limits from largest to first 10 values.</P><P></P><P>edit: The issue arise from the fact that dimenion limits are looking at the first expression, the rank expression in your case.</P><P>If you change the order of expressions showing the Value Dispensed expression as first column, you can leave your current dimension limit setting. If you don't want to change the order, you could create a hidden expression just for the dimension limit.</P><P>See updated sample file</P></BODY></HTML> Fri, 13 Nov 2015 20:21:24 GMT https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995643#M955778 swuehl 2015-11-13T20:21:24Z Re: Straight table for multiple metrics sorting https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995644#M955779 <HTML><HEAD></HEAD><BODY><P>Thank you very much Swuehl</P></BODY></HTML> Fri, 13 Nov 2015 20:32:40 GMT https://community.qlik.com/t5/QlikView/Straight-table-for-multiple-metrics-sorting/m-p/995644#M955779 Anonymous 2015-11-13T20:32:40Z