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: 
Anonymous
Not applicable

Trouble sorting by date

I have loaded data with dates that are only in June.

I then created a master calendar for the entire year.


When I graph or chart any of the data, the June data always shows first, instead of in proper chronological order (I am sorting by date).


Screen Shot 2017-07-12 at 10.51.50 AM.png


I tried adding a "sortOrder" field to the master calendar, and using it as a sort expression. It resolves the problem when my dimension is individual days (as shown below), but when I try to use month as my dimension, it reverts back to starting with June. Is there some generic fix to make the dates sort chronologically?


Screen Shot 2017-07-12 at 10.59.22 AM.png


1 Solution

Accepted Solutions
sunny_talwar

Why don't you try to sort numerically instead of an expression?

View solution in original post

5 Replies
sunny_talwar

Why don't you try to sort numerically instead of an expression?

Anonymous
Not applicable
Author

That's what I did in the first example.

sunny_talwar

So what is the issue when you sort numerically?

Anonymous
Not applicable
Author

hmph

I know I tried that before, and the sort order wasn't changing. But now it seems to be working.

Thanks.

sunny_talwar

It is working, right? I would have thought it to work... and I am glad it did...

Please close the thread.

Best,

Sunny