Are you sure that you really looked on the same field-values respectively records by your made selections? To check add just a rowno() as RowNo within the preceeding-part and add this field to your tablebox and then check again.
This was also my first gist. Therefore I checked my Database.
I have many different values (without the where-cause) in TBRKEY, but in the DB is never a leading zero in front of the numbers.
Now I checked again the values in TBRKEY and there are also numbers which are smaller than 3 digits (e.g. "23") and there are no leading zeros. In the TBRKEY-field are also numbers that are much longer (e.g. "700000000").
Hopefully I understand your answer correct
If Qlik is formating my data wrong (and I think it does), how can I prevent Qlik from this?