How to sort data by clubbed Month and year basis i.e Jan-18 Jan-19 Feb-18 Feb-19 as so on

[pranaview]

Hi All,

I want to sort data on my chart to that same months come together sorted by there year as mentioned in the subject.

I am able to get them together but year sort is not working i.e sometimes it is Jan-18 Jan-19 and other time it's coming like Mar-19 Mar-18.

I just used Month(Date) as my sorting expression.

Please let me know how i can get the desired outcome.

Thanks,
Pranav 

[m_woolf]

Try: MonthName(Date)

[pranaview]

This will just sort them as Jan-18 Feb-18 Mar-18 and so on...

[m_woolf]

Can you attach a sample qvw?

[Brett_Bleess]

Have a read through the following Design Blog post and see if this may help:

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

There are other 'calendar' related posts in the Design Blog area as well, so if this is not what you need, you can back the URL up to the Qlik-Design-Blog/ level and search further to see if you can get something that better fits things, but I hope this may put you on the right track here.

Regards,
Brett