Sorting Order in List Box

[#1]

Hi All,

I have a list box Like

UserNames
@John
#Martine
Ananth
James
David

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]

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

[#3]

Hi Gysbert,

Thanks for you help.

I Tried but it is not working.

[Gysbert_Wassenaar]

Works for me. See attached qvw.

[sunny_talwar]

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,

S