Month sort order at edit script

[nihhalmca]

Hi All,

I have a Date field (YYYYMM) in fact table and i derived Year and Month fields from Date field in fact table.

need to present Month sort order in UI like Jan, Feb ------, as of now it showing like Apr, Aug -----

have to do sort order at edit script (not at UI).

I have tried dual and applymap functions.

Dual scenario: Month contains 24 fields (12 as text and 12 as number) and no changes if i join dual table with fact as well.

Applymap scenario: I need to do resident or preceding load.

Thanks,

Nihhal.

[nihhalmca]

Hi Tresesco,

I think it is not possible in Qlik Sense.

[nihhalmca]

Ok.

Just tried for displaying Left side month names (Jan, Feb ...).

Could you tell how can i display Left side month names in month filter pane (currently it is displaying right side).

[sunny_talwar]

May be use Text(Month) as field and then sort using expression = Month

[nihhalmca]

Thanks, It's working.