Sorting Order Help

[rxp03570]

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??

[sunny_talwar]

Sort on the front end or the script?

[rxp03570]

Requirement is on the front end.

Can you please give the answer for both.

[sunny_talwar]

You can use Match function to sort

http://www.qlikfix.com/2010/10/25/creating-a-custom-sort-order/

[rxp03570]

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 · Accepted solution]

Try this sort expression

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

[rxp03570]

Thanks Sunny