Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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).
In Sorting Option,
Try Sorting Numerically,
and Deselect Sorting Alphabetically.
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.
Thank you, shraddha.g. That screenshot is not sorted alphabetically. Sorting numerically helped, but see my response above.
Try to sort by Date
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.
Have you tried generating a composite field comprised of Year and Month data and sort numerically?
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.
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).