Sort by Date

[Anonymous]

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

[Frank_Hartmann]

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]

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?