5 Replies Latest reply: Jun 13, 2017 11:24 PM by Ming Jie Hsu RSS

    Date not sorting properly when displayed as WWW MM/DD/YYYY

    Ming Jie Hsu

      Hi,

       

      I am new to QlikSense and trying to sort my chart properly as I can't seem to get it to sort properly when I want to display my date as

      WWW MM/DD/YYYY (e.g. Mon 06/25/2017 ).


      I am able to sort properly through sorting by numeric when displaying only MM/DD/YYY (Dimension used is dayname(order_date).

       

      However, when I try to use the following dimension, I am unable to sort it properly - [weekday(order_date) &' '&dayname(order_date)]

       

      Is there anyway that allows me to display my chart using WWW MM/DD/YYYY while still able to sort accordingly?

       

      Thanks!