topic Re: Complex Sorting Required in QlikView

Complex Sorting Required

erric3210 — Fri, 15 Nov 2024 23:49:44 GMT

Hi All,

I'm trying to achieve complex Sorting but not able to do so in Sort Expression.

What I want is High to Low Sorting but it has some conditions:

Sort in descending order but if there are same values before decimal like 4.112, 4.111 & 4.113 than Sort it in Ascending order like this 4.111, 4.112 & 4.113

This is what I want:

Regards,

Eric

Re: Complex Sorting Required

Sue_Macaluso — Mon, 12 Oct 2020 18:29:00 GMT

@erric3210 Are you using QlikView or Qlik Sense? I would like to move this into the correct product forum. This is generally used for non-product related discussions.

Re: Complex Sorting Required

erric3210 — Mon, 12 Oct 2020 18:52:15 GMT

Hi Ma'am,

I'm using Qlikview. Thank you so much. Appreciate that help.

Regards,

Eric

Re: Complex Sorting Required

marcus_sommer — Tue, 13 Oct 2020 14:02:37 GMT

You could try something like this as sort-expression:

rangesum(floor(Score), 1-frac(Score))

- Marcus

Re: Complex Sorting Required

erric3210 — Tue, 13 Oct 2020 15:55:36 GMT

Hi Marcus Sir,

This is exactly what I want. Your solution worked in my case.

Regards,

Eric

Re: Complex Sorting Required

erric3210 — Thu, 15 Oct 2020 00:27:55 GMT

Hi Markus Sir,

@marcus_sommer

How to handle below case:

Regards,

Eric

Re: Complex Sorting Required

marcus_sommer — Thu, 15 Oct 2020 07:33:53 GMT

What's the problem? From a sorting point of view it should equally work if there are 3 or 4 or even more digits. If the different lengths are troubling you may cut them with round(Score, 0.001) or you used a formatting to show only the wanted number of digits - whereby you could show less as exists or more, like:

num(Score, '#.00') respectively num(Score, '#.00000')

The exact format-pattern for num() depends on the used number-formatting in your application.

- Marcus

Re: Complex Sorting Required

erric3210 — Thu, 22 Oct 2020 18:59:09 GMT

Thanks again Marcus. That was logical. I got it.

Regards,

Eric