Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
It is simpler than that... There is no need to concatenate weekday and date, just use format 'WWW MM/DD/YYYY' - it is dual by its nature.
May be use Dual function here
Dual(WeekDay(order_date) &' ' & DayName(order_date), DayName(order_date))
It is simpler than that... There is no need to concatenate weekday and date, just use format 'WWW MM/DD/YYYY' - it is dual by its nature.
Hi Michael, how could I use the format from the start, am I able to use it in an expression when building a chart:
For example, do i use it like this: " dayname([order_date],WWW MM/DD/YYY) "
It is
date([order_date], 'WWW MM/DD/YYYY')
hi,
Thank you for the explanation. It worked!