Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

truppell
Contributor

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
MVP
MVP

Re: Trouble sorting by date

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

5 Replies
MVP
MVP

Re: Trouble sorting by date

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

truppell
Contributor

Re: Trouble sorting by date

That's what I did in the first example.

MVP
MVP

Re: Trouble sorting by date

So what is the issue when you sort numerically?

truppell
Contributor

Re: Trouble sorting by date

hmph

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

Thanks.

MVP
MVP

Re: Trouble sorting by date

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

Please close the thread.

Best,

Sunny