topic Simple Sort by Expression in QlikView

Simple Sort by Expression

Wed, 25 Apr 2012 21:06:52 GMT

I have a Day of Week list that uses the Weekday function to determine the day of the week. I set it up so that it has seven columns, and I get Mon trhough Sun in the list. I want Sun through Sat.

I tried loading a sort column:

if(weekday(Date)='Sun',-1,num(weekday(Date))) as WeekDaySort,

And this produces the correct numerical order that I want the sort to use.

In my List Box, on the sort tab, I placed the WeekDaySort field in the Expression, checked the Expression box, and get the correct ordering - UNTIL a selection is made. Then the ordering changes, whether or not the State is selected, with any of the three choices.... When I make a list with just the WeekDaySort, the order doesn't change at all after selections.

Simple Sort by Expression

Wed, 25 Apr 2012 21:15:24 GMT

dual(weekday(Date),if(weekday(Date)='Sun',-1,num(weekday(Date)))) as Weekday,

Then sort numerical

Simple Sort by Expression

m_woolf — Wed, 25 Apr 2012 21:20:52 GMT

Make a series of 7 listboxes. Each one displays a single day. Use an expression like this:

=if(Weekday(Weekday) = 'Sun',Weekday)

Make each lisbox small and set them side by side.

What a pain!

Simple Sort by Expression

Wed, 25 Apr 2012 21:21:06 GMT

Works great - thank you both for responding so quickly and for having the right answer!