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: 
des_1219
Contributor
Contributor

Chart Not Sorting Chronologically

Hi all,

 

The chart I created won't sort by MM/YYYY order. Sometimes it groups the month (7/2019,7/2020, 8/2019, 8/2020..) other times it seems random. I tried to sort it with the different Sorting on the charts and even tried to load a "sorting" key (1, 2, 3...) and sort ascending by that but with no luck.

 

It also seems like the data loads out of order even if I load it in order. Any suggestions?

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

My first thought would be to check the format of your month year field. Make sure it is date
des_1219
Contributor
Contributor
Author

Yeah, the data shows it is registering as a date and is in the MM/YYYY format. 

dplr-rn
Partner - Master III
Partner - Master III

in the Data model it says date?

like below

Capture.PNG