topic Re: How to sort list box with an expression in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224033#M849176 <HTML><HEAD></HEAD><BODY><P>I suspect that the "blank" buyer isn't really blank. Maybe it's a space or a number of spaces.</P><P>Try:</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If(Len(trim(Buyer))&gt;0,Buyer)</STRONG></P></BODY></HTML> Thu, 16 Mar 2017 15:11:39 GMT m_woolf 2017-03-16T15:11:39Z How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224025#M849168 <HTML><HEAD></HEAD><BODY><P>I have a list box that has some blanks in it, so I used an expression to remove them.&nbsp; Upon doing so, the sort no longer works as it did previously.&nbsp; I want to sort ascending.&nbsp; I tried changing the sort from State - Auto Ascending to Expression - Ascending and then placing the expression in the box below, but it does not seem to work.&nbsp; Here is the expression I am using:</P><P></P><P>=If(Len(Buyer)&gt;0,Buyer)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224025#M849168 cliff_clayman 2020-11-25T16:16:04Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224026#M849169 <HTML><HEAD></HEAD><BODY><P>Have you tried sorting by Text in ascending?</P></BODY></HTML> Thu, 16 Mar 2017 14:56:17 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224026#M849169 sunny_talwar 2017-03-16T14:56:17Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224027#M849170 <HTML><HEAD></HEAD><BODY><P>Yes, it does not change.&nbsp; When I just choose to sort by Text Ascending, I still get the blank value on top even with the expression.</P></BODY></HTML> Thu, 16 Mar 2017 14:58:30 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224027#M849170 cliff_clayman 2017-03-16T14:58:30Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224028#M849171 <HTML><HEAD></HEAD><BODY><P>Have you removed checks from auto and expression, just with Text it isn't working?</P></BODY></HTML> Thu, 16 Mar 2017 14:59:44 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224028#M849171 sunny_talwar 2017-03-16T14:59:44Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224029#M849172 <HTML><HEAD></HEAD><BODY><P>That is correct.&nbsp; It does sort them Ascending, but the blank still shows up first.</P></BODY></HTML> Thu, 16 Mar 2017 15:01:06 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224029#M849172 cliff_clayman 2017-03-16T15:01:06Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224030#M849173 <HTML><HEAD></HEAD><BODY><P>What is the expression used for the list box? Isn't it this guy?</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=If(Len(Buyer)&gt;0,Buyer)</STRONG></SPAN></P></BODY></HTML> Thu, 16 Mar 2017 15:07:08 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224030#M849173 sunny_talwar 2017-03-16T15:07:08Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224031#M849174 <HTML><HEAD></HEAD><BODY><P>Yes, that is the expression that I am using.</P></BODY></HTML> Thu, 16 Mar 2017 15:08:57 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224031#M849174 cliff_clayman 2017-03-16T15:08:57Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224032#M849175 <HTML><HEAD></HEAD><BODY><P>Why are you even seeing blanks then? You have me completely confused? Can you share sample or images?</P></BODY></HTML> Thu, 16 Mar 2017 15:09:56 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224032#M849175 sunny_talwar 2017-03-16T15:09:56Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224033#M849176 <HTML><HEAD></HEAD><BODY><P>I suspect that the "blank" buyer isn't really blank. Maybe it's a space or a number of spaces.</P><P>Try:</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If(Len(trim(Buyer))&gt;0,Buyer)</STRONG></P></BODY></HTML> Thu, 16 Mar 2017 15:11:39 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224033#M849176 m_woolf 2017-03-16T15:11:39Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224034#M849177 <HTML><HEAD></HEAD><BODY><P>I added a sample QVW file.</P></BODY></HTML> Thu, 16 Mar 2017 15:16:51 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224034#M849177 cliff_clayman 2017-03-16T15:16:51Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224035#M849178 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=If(Len(trim(PurgeChar(Buyer, Chr(48))))&gt;0, Buyer)</STRONG></P></BODY></HTML> Thu, 16 Mar 2017 15:20:22 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224035#M849178 sunny_talwar 2017-03-16T15:20:22Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224036#M849182 <HTML><HEAD></HEAD><BODY><P>What does that do exactly?</P></BODY></HTML> Thu, 16 Mar 2017 15:21:17 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224036#M849182 cliff_clayman 2017-03-16T15:21:17Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224037#M849186 <HTML><HEAD></HEAD><BODY><P>There are two types of blanks.... one is normal blank and the other one is some sort of character which seems to be Chr(48).... I purged it while checking for blanks</P></BODY></HTML> Thu, 16 Mar 2017 15:22:23 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224037#M849186 sunny_talwar 2017-03-16T15:22:23Z Re: How to sort list box with an expression https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224038#M849189 <HTML><HEAD></HEAD><BODY><P>Great, thanks again!!!</P></BODY></HTML> Thu, 16 Mar 2017 15:23:36 GMT https://community.qlik.com/t5/QlikView/How-to-sort-list-box-with-an-expression/m-p/1224038#M849189 cliff_clayman 2017-03-16T15:23:36Z