Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikQlaker
Contributor III
Contributor III

Sort by date and time

I'm having an issue sorting dates (with and without times).  

So far, I've tried about every combination of Date#(date,'MMM-YY') that I've read in every other post and the thing that is finally coming closest to working is to add a whole other data point for the update date, pull out the month /  year, and then sort by that. 

The issue (as shown in the pic) is that some of the date randomly don't sort properly.  I have no idea what is causing this, the sorting column is solely pulling in the above month/year combo.

Help!

1 Reply
QlikQlaker
Contributor III
Contributor III
Author

And also, this...