topic Sort Month field by Month name in App Development

Sort Month field by Month name

snehasimha — Fri, 11 Feb 2022 13:22:43 GMT

Dear All

I am very new to Qlikview, my question is I have Dimension Month and when I use this in the chart, I want to sort my Month where April should be seen in the beginning instead of Jan.I have used this =Match(Month,'Apr', 'May') but I am able to see both Months like this.I want to see only the sorted month.

Also is there a possibility to remove the values and date header.

Kindly help me

Regards

Sneha Simha

Re: Sort Month field by Month name

salonicdk28 — Fri, 11 Feb 2022 14:54:26 GMT

You can use this expression in Sort tab for sorting the month names as you like

=Only({1} Match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sept','Oct','Nov','Dec'))

or You may sort it by Month number column if you have Monthnum same in sorting tab

Only({1}MonthNum)

Thanks,

Saloni

Re: Sort Month field by Month name

snehasimha — Sat, 12 Feb 2022 08:12:23 GMT

Thanks salonicdk28

But i get the below error

Regards

Sneha simha