Skip to main content

Qlik

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
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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?

8,964 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.

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

In response to sunny_talwar

this worked in expression tab as you described

359 Views