topic Expression Sorting in QlikView

Expression Sorting

Thu, 05 Apr 2012 23:15:20 GMT

http://screencast.com/t/JoEF5nuBL. I have this dimension wich is gouped. It starts with month/year then when clicked goes to the day level. When I sort, I choose expression then put in month. The issue is when I click on the arrow for grouping and show dates they don't sort. If I choose the date when sorting then the months are wrong. How do I write an expression that will sort by month when showing months and dates when showing dates?

Expression Sorting

sivarajs — Fri, 06 Apr 2012 07:32:00 GMT

Its better to do in script level.

Use order by desc/asec in script

Sivaraj S

Expression Sorting

Jason_Michaelides — Fri, 06 Apr 2012 07:37:00 GMT

Looking at your month format I wonder if QV is actually recognising it as as date field. How are you defining month in your script? Or does it come in like "March 2012"?

Expression Sorting

Fri, 06 Apr 2012 16:06:12 GMT

It does come in as March 2012, but when I do this http://screencast.com/t/e343VPGk4Er, it sorts correctly. But in that expression I am not sure how to do month and day, depending on what the user is looking at.

Expression Sorting

Jason_Michaelides — Fri, 06 Apr 2012 19:50:54 GMT

Maybe try loading the Month and Year yourself from the date field. This way QlikView should retain the underlying numeric value and sorting should be OK.

LOAD

Field1,

Field2,

Field3,

etc,

Date,

Date(Date,'MMMM YYYY') AS MonthYear

FROM....;

Then in your cyclic dimensions just use Date and MonthYear

Jason