https://community.qlik.com/t5/App-Development/Variable-Sorting-Dependent-on-Selected-Dimension/m-p/1727755#M55475 <P>I have a series of bar chats that allow the user to change the displayed dimension by using a drop down box. Currently each graph is sorted by the total offering in each value of the selected dimension.&nbsp; The users have requested that certain dimensions be sorted by the <STRONG>value of the dimension</STRONG> instead of the sum of the offering.</P><P>&nbsp;</P><P>For instance, when looking at color, they want to see the color with the most on offer first, then the second most , etc. However, when they select a dimension that has a progressive value, such as price range or size, they want it to be sorted small, medium, large.</P><P>&nbsp;</P><P>I have tried using Dual in order to assign a numeric value to all the possible dimensions, and it works for those which have numeric components, but for those that have to be sorted on the rank of the offering, I can't get it to work. I've also tried sorting by expression, but&nbsp; have not been able to get it to work at all.</P><P>Any suggestions are welcome.</P><P><!-- Protanopia filter --><!-- Deuteranopia filter --><!-- Tritanopia filter --></P> Tue, 14 Jul 2020 16:06:13 GMT Matt_Jester 2020-07-14T16:06:13Z https://community.qlik.com/t5/App-Development/Variable-Sorting-Dependent-on-Selected-Dimension/m-p/1727755#M55475 <P>I have a series of bar chats that allow the user to change the displayed dimension by using a drop down box. Currently each graph is sorted by the total offering in each value of the selected dimension.&nbsp; The users have requested that certain dimensions be sorted by the <STRONG>value of the dimension</STRONG> instead of the sum of the offering.</P><P>&nbsp;</P><P>For instance, when looking at color, they want to see the color with the most on offer first, then the second most , etc. However, when they select a dimension that has a progressive value, such as price range or size, they want it to be sorted small, medium, large.</P><P>&nbsp;</P><P>I have tried using Dual in order to assign a numeric value to all the possible dimensions, and it works for those which have numeric components, but for those that have to be sorted on the rank of the offering, I can't get it to work. I've also tried sorting by expression, but&nbsp; have not been able to get it to work at all.</P><P>Any suggestions are welcome.</P><P><!-- Protanopia filter --><!-- Deuteranopia filter --><!-- Tritanopia filter --></P> Tue, 14 Jul 2020 16:06:13 GMT https://community.qlik.com/t5/App-Development/Variable-Sorting-Dependent-on-Selected-Dimension/m-p/1727755#M55475 Matt_Jester 2020-07-14T16:06:13Z