in the following picture you can see my problem quite well i have 35 outlets in my qvd. These are later but not all matched with the plain names. What I do not understand, what makes the top 8 different from the others. The tableviewer shows me that it is $ numeric and $ integer.
I tried to solve the problem with num and trim, but I lose the 8 outlets.
By seeing image, You have date with Text+Number data. Qlik always read with Text as Left alignment and Number as Right alignment. Henceforth, Qlik always recommends for best practice to keep either number or Text if all digits as Num data type and all digits as Text as Char/Varchar etc.
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)