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: 
Not applicable

Sort a list of numbers by their (positive) numerical value, i.e. -123 as 123

I have made a pivot table where I need to sort a list of negative and positive numbers by their (positive) numerical values, i.e. -123 is sorted as 123, but still retains its original vale of -123

To further elaborate I may add provide the following list of values and the way they are sorted:

Natural list: -250, -123, -10, 0, 9, 122, 249

Sorted list: 0, 9, -10, 122, -123, 249, -250

Assistance is appreciated

Peter Hove

1 Solution

Accepted Solutions
hector
Specialist
Specialist

Hi, if you use fabs(field) ascending and order by expresion??

rgds

View solution in original post

2 Replies
hector
Specialist
Specialist

Hi, if you use fabs(field) ascending and order by expresion??

rgds

Not applicable
Author

Thanks - it did solve the problem!