Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

Sorting is not working in table

Hello, 

I have a table as shown below; 

2.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

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

Capture.PNG

 

 

 

 

 

 

 

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

Desired Output:

1.PNG

 

thanks

Bhavesh

Labels (3)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

3 Replies
sergio0592
Specialist III
Specialist III

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator III
Creator III
Author

@rwunderlich  thank you for the information