Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use function text() to preserve the full string, including the leading zeros:
text(BusinessUnit) as BusinessUnit
Use function text() to preserve the full string, including the leading zeros:
text(BusinessUnit) as BusinessUnit