Sort by expression and then by text

[#1]

Hi community, 

I have list boxes that load expressions to exclude certain fields.  To get ones that are within the current selections at the top (not grayed out ones) I have to sort by expression, and then I use the expression that I used to create the list box.  This puts the current allowable expressions at the top of the list box. 

The issue is that those are not alphabetically ordered.  How would I order those alphabetically.  I've tryed to have two sorts at the same time with expression and text A>Z , but that didn't work.

[pover]

This might not work in your case, but the list boxes might be ordered by "load order" by default, so you might be able to get it ordered alphabetically if you sort the table alphabetically from the script the first time you load it.

Karl

[#3]

Do you know how to sort alphabetically in the script Karl?

[#4]

You need to do a Resident Load with an Order By clause

[pover]

It has to be sorted from its first load of the table in QlikView or in the QVD file if you are using a QVD file.

From example,

Load *

SQL Select *

From x.x

Order by Field

Karl