Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Sort by Expression

Hi,

I have a list-box with some text values from the database. I am using an expression = Capitalize (Field) to get the correct format.

Now, when I go to Sort->Expression and Paste the same expression as above and put it to Ascending, I am not getting the Field sorted based on Alphabetical order. How can that be achieved?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Sort by Expression

Try correcting your correct format in the script

LOAD     

     Capitalize(FIELD) as FIELD,

....

then use alphabetical sort order in your list box.

4 Replies

Re: Sort by Expression

Hi,

     What is the order which it is showing, will you please share the example of what is expected and what it is showing.

Regards,

Kaushik Solanki

Not applicable

Re: Sort by Expression

Properties . sort > check "A-Z"   & uncheck expression

otherwise check load order "Original"

MVP
MVP

Re: Sort by Expression

Try correcting your correct format in the script

LOAD     

     Capitalize(FIELD) as FIELD,

....

then use alphabetical sort order in your list box.

Not applicable

Re: Sort by Expression

Thank you swuehl..that worked well...

Community Browser