Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Tresesco,
I think it is not possible in Qlik Sense.
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).
May be use Text(Month) as field and then sort using expression = Month
Thanks, It's working.