Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
Go to Solution.
Try correcting your correct format in the script
Capitalize(FIELD) as FIELD,
then use alphabetical sort order in your list box.
What is the order which it is showing, will you please share the example of what is expected and what it is showing.
Properties . sort > check "A-Z" & uncheck expression
otherwise check load order "Original"
Thank you swuehl..that worked well...