Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sort by Date

I have a chart with dates on one axis, these are sorting by something other than date order at the moment. How do I sort by date. The links to old community posts do not work anymore.

 

Thanks

 

joe

3 Replies
Frank_Hartmann
Master II
Master II

try to num() your date

num(Yourdatefield)

try it in a textbox first. Maybe you will have to adapt the format of your datefield:

num(date#(Yourdatefield,'MM/DD/YYYY'))

Jesh19
Creator II
Creator II

Try with Num(date) or format using date() function.

sunny_talwar

I think the link to the old discussions are still getting remapped and should be available soon (in next few days). With regards to your question, is this a question for QlikView or Qlik Sense? Also, what type of object are you using? Have you made sure that the sorting is prioritized by Date first?