topic Sorting is not working in table in QlikView

Sorting is not working in table

bhaveshp90 — Sat, 16 Nov 2024 04:26:52 GMT

Hello,

I have a table as shown below;

I want to see the Lowest MTD values (Lowest 10 MTD Projects) in my table but when I tried to sort the MTD expression, it is not working. I can see the Numeric value is enabled in sort properties as shown below

What is wrong here, can someone help me what is the issue here? Attached is the file for reference

Desired Output:

thanks

Bhavesh

Re: Sorting is not working in table

sergio0592 — Thu, 14 Feb 2019 18:08:51 GMT

I can't open your attached file, but try to sort with checking "Expression". Paste your MTD formula in Expression area and Ascending.

Re: Sorting is not working in table

rwunderlich — Thu, 14 Feb 2019 19:09:16 GMT

You are using the Above() function in your expression. When using a chart inter-record function such as Above(), sorting is disabled.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Sorting is not working in table

bhaveshp90 — Fri, 15 Feb 2019 14:46:29 GMT

@rwunderlich thank you for the information