Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Perfect! Thank you for the help this is working as intended.
-Ben