Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

pranaview
Contributor II

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

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 

4 Replies
mwoolf
Honored Contributor II

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

Try: MonthName(Date)

pranaview
Contributor II

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

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

mwoolf
Honored Contributor II

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

Can you attach a sample qvw?

Support
Support

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

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.