Sort Month field by Month name

[snehasimha]

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

[salonicdk28]

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

[snehasimha]

Thanks  salonicdk28

PREVIEW

But  i get the below error 

Regards

Sneha simha