topic Re: Month sort order will be changed after selection in App Development

Month sort order will be changed after selection

kwl1234 — Mon, 20 Dec 2021 21:05:46 GMT

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.....

Re: Month sort order will be changed after selection

MayilVahanan — Thu, 28 Jan 2021 04:16:30 GMT

Hi @kwl1234

May be try like below

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

Re: Month sort order will be changed after selection

kwl1234 — Thu, 28 Jan 2021 05:16:28 GMT

Thank you. It woks😀

Re: Month sort order will be changed after selection

PradeepK — Thu, 28 Jan 2021 08:24:55 GMT

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.