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: 
rxp03570
Creator
Creator

Sorting Order Help

I am trying to sort and place a specific to the last.

Ex:

Load * inline [

Sort

Alpha,

Beta,

Charlie,

Tango,

.

.

.

.

Delta

];

I want the Charlie field to sort at last.

How can I sort this??

1 Solution

Accepted Solutions
sunny_talwar

Try this sort expression

=If(Only({1}Sort) = 'Charlie', Rank(Only({1}Sort)), -Rank(Only({1}Sort)))

View solution in original post

6 Replies
sunny_talwar

Sort on the front end or the script?

rxp03570
Creator
Creator
Author

Requirement is on the front end.

Can you please give the answer for both.

rxp03570
Creator
Creator
Author

Tried doing that, but I do have many fields. Do I have to have all the fields in the match function, Don't we have any straight solution.

Thanks

Rahul

sunny_talwar

Try this sort expression

=If(Only({1}Sort) = 'Charlie', Rank(Only({1}Sort)), -Rank(Only({1}Sort)))

rxp03570
Creator
Creator
Author

Thanks Sunny