topic data confusion in QlikView https://community.qlik.com/t5/QlikView/data-confusion/m-p/329389#M121252 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I'm reading data from a database table that has a column char(3)</P><P>in this column (code of business unit) there is data that has values 11, 011,01,02,03,....</P><P></P><P>when read to QlikView the values 11 are retrieved as 011 and thus I'm losing the 11 values</P></BODY></HTML> Wed, 30 May 2012 13:45:31 GMT ali_hijazi 2012-05-30T13:45:31Z data confusion https://community.qlik.com/t5/QlikView/data-confusion/m-p/329389#M121252 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I'm reading data from a database table that has a column char(3)</P><P>in this column (code of business unit) there is data that has values 11, 011,01,02,03,....</P><P></P><P>when read to QlikView the values 11 are retrieved as 011 and thus I'm losing the 11 values</P></BODY></HTML> Wed, 30 May 2012 13:45:31 GMT https://community.qlik.com/t5/QlikView/data-confusion/m-p/329389#M121252 ali_hijazi 2012-05-30T13:45:31Z data confusion https://community.qlik.com/t5/QlikView/data-confusion/m-p/329390#M121253 <HTML><HEAD></HEAD><BODY><P>Use function text() to preserve the full string, including the leading zeros:</P><P></P><P>text(BusinessUnit) as BusinessUnit</P></BODY></HTML> Wed, 30 May 2012 17:15:08 GMT https://community.qlik.com/t5/QlikView/data-confusion/m-p/329390#M121253 Oleg_Troyansky 2012-05-30T17:15:08Z