I am having some trouble understanding sorting logic in Qlik sense. Many a times I have observed that qlik sense desktop app randomly sorts my data (I am sure there is a reason and it just seems random to my untrained eyes). Could someone help understand this behavior. Here are a sample scenarios, would appreciate any explanation behind this behavior.
This table is sorted on Staff Member column and is built by concatenating columns 'SatffMember' and 'EmployeeID'