you were trying to order that table by fields from a different table, judging from the prefixed table_name - only the first field you want to order by seems to be in the primary table, that will work.
To sort by the others, you would have to join those fields.
I originally load from Excel into table HRP1001Temp1 simply because I apparently cannot order there; then I do the load resident into HRP1001Temp1 for the purpose of ordering and using cross-records (peek) functions....
While seeing the error message you will get to know which field is making the problem. After finding the field go and check for proper field name (May be there may different in cases because QlikView is Case Sensitive ).
