topic Re: List Box sort in QlikView

List Box sort

danialier — Mon, 20 Jan 2014 15:05:16 GMT

Hello,

I have a list box as follows:

3m printers

5m printers

HE printers

hybrid printers

production above 80 printers

production from 50 printers

I want the list box to be sorted as follows:

HE printers

5m printers

3m printers

hybrid printers

production above 80 printers

production from 50 printers

How I can do that ? I did not find the way to do that through the sort options in the sort tabrow under the List Box properties...

Please help.

Thanks,

dani

Re: List Box sort

Nicole-Smith — Mon, 20 Jan 2014 15:06:22 GMT

Sort by expression:

match(YourField,

'HE printers',

'5m printers',

'3m printers',

'hybrid printers',

'production above 80 printers',

'production from 50 printers')

Re: List Box sort

danialier — Mon, 20 Jan 2014 15:38:28 GMT

Hi Nicole,

This is what I did but it does not work…

Am I missing anything ?

Thks,dani

Re: List Box sort

Nicole-Smith — Mon, 20 Jan 2014 15:41:21 GMT

You need to put whatever field has those values in the place where I have YourField:

match(YourField,

'HE printers',

'5m printers',

'3m printers',

'hybrid printers',

'production above 80 printers',

'production from 50 printers')

Re: List Box sort

Anonymous — Mon, 20 Jan 2014 15:41:31 GMT

You forgot to put the field name as the first argument in the expression.

Re: List Box sort

Mon, 20 Jan 2014 15:42:56 GMT

HeY Dani,

I think you forgot the field name.

Thanks

Re: List Box sort

giakoum — Mon, 20 Jan 2014 15:48:14 GMT

I would suggest using the dual function. Adding an order number to each value. This way sort would be much more efficient with QV.

Dual

dual( s , x )

Forced association of an arbitrary string representation s with a given number representation x. In QlikView, when several data items read into one field
have different string representations but the same valid number representation,
they will all share the first string representation encountered. The dual
function is typically used early in the script, before other data is read into
the field concerned, in order to create that first string representation, which
will be shown in list boxes etc.

Example:

load dual ( string,numrep ) as DayOfWeek inline

[ string,numrep

Monday,0

Tuesday,1

Wednesday,2

Thursday,3

Friday,4

Saturday,5

Sunday,6 ];

load Date, weekday(Date) as DayOfWeek from afile.csv;

The script example will generate a field DayOfWeek
with the weekdays written in clear text. QlikView will for all purposes (including sort) regard the field as a numeric field.

Re: List Box sort

danialier — Mon, 20 Jan 2014 15:51:04 GMT

Excellent now it works !!!

However when I select a filter, the selection goes to the bottom of the list box… and I want this list box to be fixed whatever value I select from the List Box. Do you know how to do that ?

Thanks !

dani

Re: List Box sort

Nicole-Smith — Mon, 20 Jan 2014 15:53:39 GMT

match(only({1}YourField),

'HE printers',

'5m printers',

'3m printers',

'hybrid printers',

'production above 80 printers',

'production from 50 printers')

Re: List Box sort

danialier — Mon, 20 Jan 2014 15:58:40 GMT

Excellent !!!! It works now. Many thanks Nicole !