Sorting Order

[riyazasma1009]

Hi All,

I have a list box with the below field values:

1. AT

2. Al

3. Non

The values in the list box should be displayed in the order:

Al

Non

AT

Can anyone please help with the sorting?

Thanks,

Asma

[tamilarasu · Accepted solution]

Hi Asma,

Try sort expression as

Match(Field_Name, 'Al','Non','AT')

[Anonymous]

Tamil Nagaraj‌

have already given the best solution, though you can try like this as well?

Replace the same expression with following one:

IF(FieldName='AI',1,

IF(FieldName='Non',2,

IF(FieldName='AT',3)))

[amit_saini]

Asma,

See the attachment.

Thanks,

AS

[riyazasma1009]

Thanks Tamil Nagaraj for the quick reply!!

It worked..

[amit_saini]

Did u tried my suggestion???

Thanks,
AS

[riyazasma1009]

Hi Amit,

Thanks for the reply!!

I tried your solution as well. It works too.

Just wanted some clarification on the use of dual in the expression.

[amit_saini]

check below:

https://community.qlik.com/docs/DOC-8106

Thanks,

AS

[Anonymous]

Duel() is nothing but just assigned a numeric value to a string value. check this?

Dual & Exists – Useful Functions

[sauliusr]

If these field values came from inline load in script, just change order in script and check box "Load Order" in Sort tab.