data confusion

[ali_hijazi]

Hello

I'm reading data from a database table that has a column char(3)

in this column (code of business unit) there is data that has values 11, 011,01,02,03,....

when read to QlikView the values 11 are retrieved as 011 and thus I'm losing the 11 values

[Oleg_Troyansky · Accepted solution]

Use function text() to preserve the full string, including the leading zeros:

text(BusinessUnit) as BusinessUnit