Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date not sorted correctly

Hello,

I am sure this question has been asked before but I can't seem to find the answer.  I have

a selection box which contains dates in the following format:

01-DEC-2017

15-DEC-2017

22-NOV-2017

How do I get these values to be sorted in time chronological order?

Thanks!

25 Replies
Anonymous
Not applicable
Author

Sorry... nevermind.  I forgot to change it to "sort by numeric".  It's working now.

t_chetirbok
Creator III
Creator III

your chart should be sorted in descending order

Anonymous
Not applicable
Author

No, I need the chart to be sorted in "ascending" order.  Oldest starts on left.

t_chetirbok
Creator III
Creator III

oh, sure! can you send a screenshot of your sort pages in the chart?

Anonymous
Not applicable
Author

Hi Tatsiana,

Attached is a screenshot of the chart.  What I have now seems to be working as I expected.

date_sort_4.jpg

vishsaggi
Champion III
Champion III

Can you close the thread if you got the answer marking helpful/correct responses. IF you still facing issues share your sample app here to look into and your expected output.