It is clear when sorting dates in a list box when the field is the date, and it functions properly.
But if the field is not the date, and I try to sort by another field containing the related date, it fails applying a different sorting that I cannot understand.
I had a list box that must show the name of a season, and each season had an initial date related.
So, I created the list for the name of season field, and I tried to sort from the Sort tab, selecting the related date field as Expression, and it does not sort properly the list, some of the items seem ordered but some are missplaced, and I cannot understand what QlikView is doing.
The date related field has been loaded from a DateTime field from a SQL Server table.
I have finally understood what happened. There were some different dates related to each season name, not only one, and QlikView was confused when sorting. Applying the MIN group function to obtain the earliest initial date for each season makes the sorting work fine.