Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Sorting Order in List Box


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.

4 Replies
MVP & Luminary
MVP & Luminary

Re: Sorting Order in List Box

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


talk is cheap, supply exceeds demand
Not applicable

Re: Sorting Order in List Box

Hi Gysbert,

Thanks for you help.

I Tried but it is not working.


MVP & Luminary
MVP & Luminary

Re: Sorting Order in List Box

Works for me. See attached qvw.


talk is cheap, supply exceeds demand

Re: Sorting Order in List Box

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