Sort order will change after make selection

[KP_8859]

Hi I have set the custom order by east to west of Canada's jurisdiction, but when i select any 1 jurisdiction, it will change and become default sort alphabetical sort order. 

i have used the formula =only(Jurisdiction_Sort_Order)

[rwunderlich · Accepted solution]

You will need to add the set {1} (ignore selections) to your sort expression. 

=only({1}Jurisdiction_Sort_Order)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[KP_8859]

Thanks  Rwunderlich . Its working for me.