Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rish
Contributor III
Contributor III

Month Field Sorting

I created a month field using the following expression:

Month(DateField)&' '&Year(DateField)

 

But I can't sort it properly, I was able to get it sorted in the order of years but not with months. Can anybody help me with this? what expression can i use for this? 

1 Solution

Accepted Solutions
sunny_talwar

Create it like this instead

Date(MonthStart(DateField), 'MMM YYYY')

View solution in original post

2 Replies
sunny_talwar

Create it like this instead

Date(MonthStart(DateField), 'MMM YYYY')
rish
Contributor III
Contributor III
Author

Hi thanks, it works!!!