Dimension sort

Mon, 19 Apr 2010 18:06:10 GMT

Well, the issue doesn't seem to be resolved. Even when it was sorting the days before the weeks it was not sorting the days int he right order. Attached is a screen shot of what it is doing now. Starts at week 14 and goes to 1 then lists week 15 days. I want it to be in Descending order starting at the most recent week/day.

Any thoughts?

Attached is a screen shot of what it is doing.

below is my dimension code

= if(Week < vCurrentWeek, ' ' & Week, if(Week = vCurrentWeek, if(DayOfWeek < vDayOfWeek, Week & ' - ' & DayOfWeekAlpha)))

Dimension sort

Oleg_Troyansky — Mon, 19 Apr 2010 20:44:29 GMT

Your expression returns a String, and Strings are sorted just the way it shows - "15" goes before "2". If you have to use strings, you can at least format the Week number to always show 2 digits:

= if(Week < vCurrentWeek, ' '
& num(Week, '00'), if(Week = vCurrentWeek, if(DayOfWeek < vDayOfWeek, num(Week, '00')
& ' - ' & DayOfWeekAlpha)))

topic Dimension sort in QlikView

Dimension sort

Dimension sort