Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.