Month sort order will be changed after selection

[kwl1234]

If I don't choose any selection, the sort order is  normal.

However, when I select month, the sort order will be changed. It always Nov and Dec on the Top.

Sorting expression Date(Date#(LINK_Month,'MMM'))

Could it possible sorting the month after selection e.g Jan,Feb,Mar.....

[MayilVahanan · Accepted solution]

Hi @kwl1234 

May be try like below

Date(Date#(only({1}LINK_Month),'MMM'))

[kwl1234]

Thank you. It woks😀

[PradeepK]

I suggest you to look into your field tags.... you do not have to add sort expression every time.. This should be interpreted as NUM / INT... and not ASCII / STRING 

 Qlik Sense automatically aligns text fields to left side to highlight this.. same as in your shared screenshot.

Below is the sample reference.

Once you have your field in correct type.. sorting should be automatic.. 

 I hope this helps.