This content has been marked as final. Show 5 replies
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?