topic Re: Using Autonumber and sort order in an expression in QlikView

Using Autonumber and sort order in an expression

tinkerz1 — Thu, 02 Jul 2015 11:55:44 GMT

Hi,

I can't get an expression in sort order to work, here is my setup:

In the load script I have:

Autonumber([ABC]&[DEF]) as Column1

Then in the properties>general>field I select 'Column1'

In Expression I set up

Only({1}[ABC])

Only({1}[DEF])

I set sort order to by a tick in STATE and Ascending

Then an expression in sort

={ABC]

But this does not work, and I would like to so by ABC as the primary key and DEF as the secondary

I would like both selected and not selected in the list to be sorted.

Gysbert_Wassenaar — Thu, 02 Jul 2015 11:57:59 GMT

Try sorting with =only({1}[ABC])

If I misunderstood you, then please explain in more detail. I'm afraid your post is not all that clear to me.

tinkerz1 — Thu, 02 Jul 2015 12:17:09 GMT

I have tried =only({1}[ABC]) and its sorts but its not alpabetical, i can not tell what the order is meant to be.

I seems that using autonumber in the load script is affecting the sort order expression

I want to autonumber to create a unique ket into a list box dimension

Then I want to sort alphabetically by an expression.

I can seem to get an expression in sort to work across an unselected expression

Thanks,

Neil.

tinkerz1 — Thu, 02 Jul 2015 13:40:12 GMT

Is this a solution:

once I autonumber the a joined field I then load into a resident table and use order by

So is there a quick way to make a resident table from a long list of fields

ie.

tab1:

Select * from transtable;

Load * resident tab1 order by C desc, B asc, 1 desc;

Will that work?