topic Sorting Order in List Box in QlikView

Sorting Order in List Box

Wed, 11 Mar 2015 12:42:32 GMT

Hi All,

I have a list box Like

If i sort the data in alphabetical order the null and the Special character value are coming on the top.

Q) Is ther any chanse that will sort 1st in alphabetical order names then special character names and then the null value will come.

Please suggest me.

Thanks.

Gysbert_Wassenaar — Wed, 11 Mar 2015 12:57:27 GMT

Sort by expression =if(ord(left(UserNames,1))>64,1,if(len(trim(UserNames))=0,3)) and the A->Z ascending

Wed, 11 Mar 2015 13:36:32 GMT

Hi Gysbert,

Thanks for you help.

I Tried but it is not working.

Gysbert_Wassenaar — Wed, 11 Mar 2015 13:39:01 GMT

Works for me. See attached qvw.

sunny_talwar — Wed, 11 Mar 2015 13:50:32 GMT

May be this might help:

Table:

LOAD UserNames as [User Names],

Purgechar(UserNames, '#@ ') as UN

FROM

[http://community.qlik.com/thread/155687]

(html, codepage is 1252, embedded labels, table is @1);

Table1:

NoConcatenate

LOAD [User Names] as UserNames

Resident Table

Order By UN asc;

DROP Table Table;

and then do a load order in the sorting.

Best,