Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
tchambers
New Contributor II

Auto-generated calendar months sort wrong

I have a table with a date field. I used the Data manager to create a MasterCalendar. It found my date columns correctly (both Created and Updated). But in this chart the months are sorted wrong (Feb, Apr, May, Mar, Jun, Aug, Jul). Order should be Feb, Mar, Apr, May, Jun, Jul, Aug.

I'm using qliksensedesktop 11.11.1 (June 2017).

What am I missing?

auto-generated-months-sort-wrong-e1009b.png

Tags (1)
1 Solution

Accepted Solutions

Re: Auto-generated calendar months sort wrong

Hi Tim, If you sort by expression "Min(DateField)" ir should keep December first (at least if december of last year has the min date).

12 Replies
Chanty4u
Esteemed Contributor III

Re: Auto-generated calendar months sort wrong

Partner
Partner

Re: Auto-generated calendar months sort wrong

In Sorting Option,

Try Sorting Numerically,

and Deselect Sorting Alphabetically.

tchambers
New Contributor II

Re: Auto-generated calendar months sort wrong

Thank you, sureshqv. That post was helpful, but I forgot to mention that my data spans across a year boundary. I want to see December from the previous year before the data from the current year. I'm going to try scripting a solution.

tchambers
New Contributor II

Re: Auto-generated calendar months sort wrong

Thank you, shraddha.g‌. That screenshot is not sorted alphabetically. Sorting numerically helped, but see my response above‌.

antoniotiman
Honored Contributor III

Re: Auto-generated calendar months sort wrong

Try to sort by Date

tchambers
New Contributor II

Re: Auto-generated calendar months sort wrong

Thank you for responding, antoniotiman‌. I'm using a bar chart with a list of alternative dimensions. When I display Created.Date it sorts correctly. As my screenshot shows, I'm having trouble with Created.Month. See my response above for my current plan to solve my problem.

cazztfplease
Contributor

Re: Auto-generated calendar months sort wrong

Have you tried generating a composite field comprised of Year and Month data and sort numerically?

Khan_Mohammed
Honored Contributor II

Re: Auto-generated calendar months sort wrong

Add sort script and use that sorting field in front end

Load * Inline [

Created.Months,     SortingOrder

Jan                               1

Feb                               2

Mar                               3

Apr                               4

May                              5

Jun                               6

Jul                                7

Aug                              8

Sep                              9

Oct                              10

Nov                             11

Dec                             12

];

Probably use SortingOrder in your settings? Guess that should work.

Re: Auto-generated calendar months sort wrong

Hi Tim, If you sort by expression "Min(DateField)" ir should keep December first (at least if december of last year has the min date).