Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-10-20 04:14 AM

Sorting of Date field

Hi..

I have a date field named ProjectMonth. Data in this field is as below Aug-2015, Jul-2015 etc.

When I try to plot this field on the X axis these dont appear in the sorted fashion. I am guessing the reason may be that it is being stored as Text so I used num#(ProjectMonth) but I am still not able to sort the months in ascending order.

Can anybody please help or suggest a way out?

Labels (1)
Labels
11,823 Views
0 Likes
11 Replies
daniellial
Contributor III
Contributor III
‎2015-10-20 06:31 AM

In response to sunny_talwar

Just change your dimension in the chart as I said.

843 Views
Anonymous
Not applicable
‎2015-10-20 06:37 AM
Author

In response to sunny_talwar

this worked in expression tab as you described

843 Views