topic Re: Alphabetical Sort With Multiple Exceptions in App Development

Alphabetical Sort With Multiple Exceptions

BenkV — Sat, 16 Nov 2024 21:33:38 GMT

Hi Qlik Community,

I am trying to sort a table alphabetically, but with two exceptions which should always appear at the top (assuming they exit within the selection). There are only x distinct values; A, B, C, D, E, G, X & Y. However I want Y then X to appear before the alphabetical sort.

I've tried multiple suggestions on the community, as well as creating an additional table in my app which assigns each value a number, then sorting numerically, but no luck.

Your help would be greatly appreciated! I'm very new to Qlik but this is the first time I've become truly stumped!

-Ben

Re: Alphabetical Sort With Multiple Exceptions

rwunderlich — Tue, 22 Jan 2019 18:21:03 GMT

There are a couple of approaches. A simple and flexible technique is to establish a load order.

https://qlikviewcookbook.com/2012/11/establishing-a-sort-order/

Setting "Load Order" for a column in a Qlik Sense chart is set Sorting to Custom and uncheck all the sort options.

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

Re: Alphabetical Sort With Multiple Exceptions

BenkV — Tue, 22 Jan 2019 16:12:42 GMT

Perfect! Thank you for the help this is working as intended.

-Ben