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
