topic Re: Sort by Date in Water Cooler

Sort by Date

Anonymous — Wed, 14 Nov 2018 11:15:05 GMT

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

Re: Sort by Date

Frank_Hartmann — Wed, 14 Nov 2018 11:22:10 GMT

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'))

Re: Sort by Date

Jesh19 — Wed, 14 Nov 2018 11:23:18 GMT

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

Re: Sort by Date

sunny_talwar — Wed, 14 Nov 2018 12:12:05 GMT

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?