Sorting is not working in table

[bhaveshp90]

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

[sergio0592]

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

[rwunderlich · Accepted solution]

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

[bhaveshp90]

@rwunderlich  thank you for the information