topic Sort by expression and then by text in QlikView

Sort by expression and then by text

Wed, 28 Mar 2012 18:55:17 GMT

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.

Sort by expression and then by text

pover — Wed, 28 Mar 2012 19:04:22 GMT

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

Sort by expression and then by text

Thu, 29 Mar 2012 15:07:09 GMT

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

Sort by expression and then by text

Thu, 29 Mar 2012 15:09:31 GMT

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

Sort by expression and then by text

pover — Thu, 29 Mar 2012 19:09:47 GMT

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