topic Re: Custom Sort Order? in QlikView

Custom Sort Order?

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the following table:

What I need is to SORT the table like this:

By showing number 03 after 05

Do you know how could I do this?

I used a quick fix by doing the following in the script: IF(ORDER='03','05.5',ORDER) AS ORDER

Then I SORT by Expression with field ORDER ascending (01 - 02 - 04 - 05 - 05.5 - 06 - 07).

Is there any other better way?

Thank you!!!

sunny_talwar — Mon, 11 Jul 2016 14:23:58 GMT

Seems like a good way to handle it. What's the concern here?

microwin88x — Mon, 11 Jul 2016 14:25:46 GMT

I wanted to know if is there any direct way to use from SORT in Expression instead of touching the script?

sunny_talwar — Mon, 11 Jul 2016 14:29:06 GMT

Have you tried this expression for the sort expression:

IF(ORDER='03','05.5',ORDER)

sunny_talwar — Mon, 11 Jul 2016 14:29:40 GMT

or may be this:

Match(ORDER, '01', '02', '04', '05', '03', '06', '07')

microwin88x — Mon, 11 Jul 2016 14:43:15 GMT

Thank you!!!