Sorting Values in Current selection bar Qliksense

pravinkumar_s — Mon, 14 Jan 2019 09:11:37 GMT

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

Re: Sorting Values in Current selection bar Qliksense

SteveNewman — Mon, 14 Jan 2019 15:44:46 GMT

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.

topic Sorting Values in Current selection bar Qliksense in Integration, Extension & APIs

Sorting Values in Current selection bar Qliksense

Re: Sorting Values in Current selection bar Qliksense