This is not an issue. QlikView does not have data types, all values are interpreted and represented either numeric or literal, or both (dual). When you want a field to be loaded into QlikView as it comes from the database (literal), regardless its type in the source, use the Text() function:
Table: LOAD Text(Value) AS Value; // will keep preceding zeroes SQL SELECT Value FROM dbo.Table;
Hope that helps.
Thanks Miguel. It works.
By the way, this is the first time that I face this issue. I've never used the text() function to load values because all data that my QV apps loaded, were complete and similar to their sources. It seems that, from now on, I have to use text() to load sensible data.
Just in case, do you know if this issue is related to this QV version?