topic Custom Sort By Expression in QlikView https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311501#M1198294 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; In sort tab--&gt;uncheck the sort by state option which makes possible or selected values to the top.</P><P></P><P>Celambarasan</P></BODY></HTML> Fri, 13 Apr 2012 10:18:17 GMT CELAMBARASAN 2012-04-13T10:18:17Z Custom Sort By Expression https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311494#M1198287 <HTML><HEAD></HEAD><BODY><P>Hi. I have a dimension in a pivot table called Label.</P><P>The values of the labels are text strings. There are 5 of them.</P><P>'Very Big Label'</P><P>'Medium Big Label'</P><P>'Small Label'</P><P>'Default Label'</P><P>'Insignificant Label'</P><P></P><P>The people I am building the report for always want to see the labels in this order. I can't sort by Text, or Load order, or frequency, so I am wondering if I can create a custom expression to sort them in this order. But I am not very good with the expression language. Can anyone help me write an expression which will sort them in the correct way?</P><P></P><P>Thanks,</P><P>-JC</P><P></P></BODY></HTML> Mon, 07 Mar 2011 20:49:03 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311494#M1198287 2011-03-07T20:49:03Z Custom Sort By Expression https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311495#M1198288 <HTML><HEAD></HEAD><BODY><P>Sort by the Result of the MATCH-function:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">MATCH(CustomerRank, 'Very Big Label', 'Medium Big Label', 'Small Label', 'Default Label', 'Insignificant Label')</PRE></BLOCKQUOTE><BR /><BR /> <P>HTH<BR />Peter</P></BODY></HTML> Mon, 07 Mar 2011 20:52:59 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311495#M1198288 prieper 2011-03-07T20:52:59Z Custom Sort By Expression https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311496#M1198289 <HTML><HEAD></HEAD><BODY><P>I am trying to get this to work. In your formula what is CustomerRank?</P></BODY></HTML> Mon, 07 Mar 2011 22:03:11 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311496#M1198289 2011-03-07T22:03:11Z Custom Sort By Expression https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311497#M1198290 <HTML><HEAD></HEAD><BODY><P>This should be your fieldname for the grouping of the customers.</P><P>++<BR />Peter</P></BODY></HTML> Mon, 07 Mar 2011 22:05:38 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311497#M1198290 prieper 2011-03-07T22:05:38Z Custom Sort By Expression https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311498#M1198291 <HTML><HEAD></HEAD><BODY><P>The field name with these values is Label. Is that what you mean?</P></BODY></HTML> Mon, 07 Mar 2011 22:48:02 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311498#M1198291 2011-03-07T22:48:02Z Custom Sort By Expression https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311499#M1198292 <HTML><HEAD></HEAD><BODY><P>yes!</P><P>++<BR />Peter</P></BODY></HTML> Tue, 08 Mar 2011 16:40:39 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311499#M1198292 prieper 2011-03-08T16:40:39Z Custom Sort By Expression https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311500#M1198293 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>this Match expression works great to sort my list box content being "red", "yellow", "green". </P><P>However, as soon as I select a value, this value is moved to the bottom of the list which is quite confusing for the user. How do I keep it from moving when I select?</P></BODY></HTML> Fri, 13 Apr 2012 10:10:06 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311500#M1198293 2012-04-13T10:10:06Z Custom Sort By Expression https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311501#M1198294 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; In sort tab--&gt;uncheck the sort by state option which makes possible or selected values to the top.</P><P></P><P>Celambarasan</P></BODY></HTML> Fri, 13 Apr 2012 10:18:17 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311501#M1198294 CELAMBARASAN 2012-04-13T10:18:17Z Custom Sort By Expression https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311502#M1198295 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>somehow I got it to work, but I don't know how. The "sort by state" option is actually disabled at this moment. See below. Perhaps that is triggered by some other setting. But now I know what that option is doing - thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P><IMG alt="ScreenShot_04 Apr. 13 15.25.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/12981_ScreenShot_04+Apr.+13+15.25.jpg" /></P></BODY></HTML> Fri, 13 Apr 2012 13:27:39 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-By-Expression/m-p/311502#M1198295 2012-04-13T13:27:39Z