Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Try this sort expression
=If(Only({1}Sort) = 'Charlie', Rank(Only({1}Sort)), -Rank(Only({1}Sort)))
Sort on the front end or the script?
Requirement is on the front end.
Can you please give the answer for both.
You can use Match function to sort
http://www.qlikfix.com/2010/10/25/creating-a-custom-sort-order/
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
Try this sort expression
=If(Only({1}Sort) = 'Charlie', Rank(Only({1}Sort)), -Rank(Only({1}Sort)))
Thanks Sunny