I've been having trouble with sorting since I first started using QlikView a couple of months ago, but it seems to have gotten worse since installing SR1 last week. Problem #1 is that tables seem to laugh at the Sort tab, and only pay attention to which columns have been sorted via the context menu in the frontline UI, but before I can even get to that, I'd like to get a simple list box sorting correctly.
My data includes two fields, ServiceRep and ServiceRepLastName. I'd like to display the former and sort by the latter (actually, sort by the combination of the two, to handle reps with the same last name). So I create a list box for ServiceRep and set Sort to Expression: ServiceRepLastName & '_' & ServiceRep. The output is sorted apparently randomly, neither by ServiceRep nor by ServiceRepLastName.
So I create another list boxes based on ServiceRepLastName. It sorts fine if I just set it to Text, but sorting by Expression: ServiceRepLastName or ServiceRepLastName & '_' & ServiceRep gives the same bizarre ordering the previous list box.
So I create another list box, populated with ServiceRepLastName & '_' & ServiceRep. Again, it sorts fine when sorting by Text, but sorted by Expression: ServiceRepLastName or Expression: ServiceRepLastName & '_' & ServiceRep, I get garbage, though not the same order as the two previous tests.
I know the expression is fine, because it looks exactly like I expect it to the the third list box. Has anyone else seen this behavior? Should I raise it as a bug, or am I missing something simple? I could use some cumbersome workaround, like pre-sorting the data and sorting by load order, or creating a separate table for these names, adding a serial number, and sorting by that... but I'd rather the software just sorted by the expression given.
FYI, using just "ServiceRepLastName" as my sort expression does not work either. I've attached a stripped-down version which truncates the names, as a half measure to protect the privacy of the reps in question.
