Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND 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.

sunny_talwar

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