I have a field [Payment Timing] storing values from -200 to 200. [Payment Timing] is to be used as the dimension of a bar chart.
In order to group the extreme values together, I have set the dimension to be
=If([Payment Timing]<-9,'<-9',If([Payment Timing]>9,'>9',[Payment Timing]))
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:
Load * Inline
But this failed to load.
May I know how should I modify my script, or Qlik Sense does not support this?