However, if I sort the dimension based on [Payment Timing], '<-9' and '>9' will appear in the middle of the axis, which they should appear at the left and and right end respectively.
I learn from other websites that I can define the sort order in the load script like this:
PaymengTiming_Sort:
Load * Inline
[
Payment Timing,
<-9
-9
-8
-7
-6
-5
-4
-3
-2
-1
0
1
2
3
4
5
6
7
8
9
>9
];
But this failed to load.
May I know how should I modify my script, or Qlik Sense does not support this?