Discussion board where members can get started with QlikView.
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.
Sort by expression =if(ord(left(UserNames,1))>64,1,if(len(trim(UserNames))=0,3)) and the A->Z ascending
Thanks for you help.
I Tried but it is not working.
Works for me. See attached qvw.
May be this might help:
LOAD UserNames as [User Names],
Purgechar(UserNames, '#@ ') as UN
(html, codepage is 1252, embedded labels, table is @1);
LOAD [User Names] as UserNames
Order By UN asc;
DROP Table Table;
and then do a load order in the sorting.