Convert Month Number to Month Name in Multi select Button and keep correct month order

[ZebLearney]

Hi, New to Qlik Sense and I have created a multi select button for months, but I want the months to display as the month name but keep the correct month order, ie Jan to Dec. Can anyone help please? Thanks

[Taoufiq_Zarra]

@ZebLearney  if I understood correctly

in sort use sort by number

[ZebLearney]

The months are currently displayed as numbers 1-12, but I want to convert them to name Jan-Dec, but still keep the sort order correct as Jan-Dec. It is a multi select button I have created, custom object field UI with field Month. Thanks

[Taoufiq_Zarra]

Month(Date) and sort by number

can you share a sample data if if this is not what I understood

[ZebLearney]

This is what I have

[ZebLearney]

=Month(Date) worked! Thanks

[Taoufiq_Zarra]

the problem is solved?

[ZebLearney]

Yes that part solved thankyou @Taoufiq_Zarra . I have another problem now. I want to have a default on this month selector to select current month via an Action, do you know what the expression should be on the action to do this? Basically when I open the report it should automatically default to the current month selected. Thanks