Qlik doesn't have data-types else the data will be interpreted as string, numeric or dual() - mainly based on the first field-value. In the most scenarios this worked well but in some cases mostly with leading spaces or zeros it may not fit to the wanted results. In such cases the field might be wrapped with a text() function, for example:
load text(field) as field; sql select field from db;
Qlik doesn't have data-types else the data will be interpreted as string, numeric or dual() - mainly based on the first field-value. In the most scenarios this worked well but in some cases mostly with leading spaces or zeros it may not fit to the wanted results. In such cases the field might be wrapped with a text() function, for example:
load text(field) as field; sql select field from db;
