Discussion board where members can get started with Qlik Sense.
I need to establish a custom sort (as per Division).
Data comes in disordered.
After that, I sort the Divisions as follows:
load * inline
But, it doesn't work.
If I use Custom-Sort / numerical, the sort-order isn't as above.
What am I doing wrong ?
Go to Solution.
Hi Reinhold, first load the mapping table (you left the close bracket, and doesn't needs to be between single quotes):
then load the divisions applying the map:
LOAD Dual([Test],Applymap('TextSort',[Test]) as Division;
(ooxml, embedded labels, table is [03) Divisionen]);
Thanks a lot - working now
For other newbies: