Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

JW_09
New Contributor

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
Honored Contributor II

Re: Sort by Date

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

Highlighted
jeshwanth19
Contributor II

Re: Sort by Date

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

Re: Sort by Date

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?