topic Re: Sorting Order in QlikView

Sorting Order

riyazasma1009 — Fri, 02 Sep 2016 06:41:46 GMT

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:

Non

Can anyone please help with the sorting?

Thanks,

Asma

Re: Sorting Order

tamilarasu — Fri, 02 Sep 2016 06:44:23 GMT

Hi Asma,

Try sort expression as

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

Re: Sorting Order

Anonymous — Fri, 02 Sep 2016 08:18:37 GMT

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)))

Re: Sorting Order

amit_saini — Fri, 02 Sep 2016 09:19:17 GMT

Asma,

See the attachment.

Thanks,

Re: Sorting Order

riyazasma1009 — Fri, 02 Sep 2016 10:38:47 GMT

Thanks Tamil Nagaraj for the quick reply!!

It worked..

Re: Sorting Order

amit_saini — Fri, 02 Sep 2016 10:42:01 GMT

Did u tried my suggestion???

Thanks,
AS

Re: Sorting Order

riyazasma1009 — Fri, 02 Sep 2016 10:47:59 GMT

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.

Re: Sorting Order

amit_saini — Fri, 02 Sep 2016 11:21:02 GMT

check below:

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

Thanks,

Re: Sorting Order

Anonymous — Fri, 02 Sep 2016 11:23:04 GMT

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

Dual & Exists – Useful Functions

Re: Sorting Order

sauliusr — Fri, 02 Sep 2016 13:49:11 GMT

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