topic Re: Sort By Expression not working as expected in Qlik Sense in App Development

Sort By Expression not working as expected in Qlik Sense

wdchristensen — Wed, 12 Sep 2018 15:09:36 GMT

I created a pivot table with columns with the days of the week, using the WeekDay() function which returns a dual. I want to show the days as text and sort the columns (Left to Right by the numeric value). For some reason when I try to use the sort by expression option and enter in the num(weekday(WORKED_DATE, 6)) it won’t change the sort order. I have attached a screenshot with green around the desired sort order. Any advise that can help me figure out what I am missing would be greatly appreciated! Thanks

Re: Sort By Expression not working as expected in Qlik Sense

YoussefBelloum — Wed, 12 Sep 2018 15:10:58 GMT

Hi,

if it is dual, on it's sorting properties, check sorting on numerical values

Re: Sort By Expression not working as expected in Qlik Sense

wdchristensen — Wed, 12 Sep 2018 15:16:40 GMT

Hi Youssef,

Thanks for the response. Unfortunately it doesn't have an effect. I also tried to multiply the result by 1 to force a numeric result. No luck...

Re: Sort By Expression not working as expected in Qlik Sense

YoussefBelloum — Wed, 12 Sep 2018 15:21:32 GMT

try this:

Dual(Weekday() ,num(WeekDay())

Re: Sort By Expression not working as expected in Qlik Sense

wdchristensen — Wed, 12 Sep 2018 15:36:52 GMT

So I figured out the issue. I was using

=TEXT(WeekDay(WORKED_DATE, 6))

for the column when I should have used

=WeekDay(WORKED_DATE, 6)

This allows you to select the numeric value in the sort order.

Seems odd that it would not work the other way also...