Sorting Values in Current selection bar Qliksense

[pravinkumar_s]

I have a Field "Month" which has values 'Jan','Feb',...,'Dec'. I created an inline load for month_value.

Load * inline [

month,month_value

Jan,1

Feb,2

Mar,3

.

.

.

Dec,12

];

I used only({1}month_value) in sorting values of filter pane. But the issue is in the Current Selection bar, it is always sorted alphabetically. I even tried sorted load in the script (after resident order by month_value) but it didn't help.

Please find the screenshot below,

Thanks in Advance,

Pravinkumar

[SteveNewman]

you may want to do something like this...

[tableName]:
load * inline....

[tableName_NEW]:
load dual(month, month_value) as Month
RESIDENT tableName;

Now when you use "month" it will have a text and number representation. Then you can set your sort order to be numeric and it will work correctly.