topic Re: Problem with database load in QlikView https://community.qlik.com/t5/QlikView/Problem-with-database-load/m-p/1228036#M622033 <HTML><HEAD></HEAD><BODY><P>The first record loaded had a leading 0 in MySQL. QV uses this value to determine the format for the values of that field. If the value is a true number (ie the 0 is not needed), then Num(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">NationalRegNumber) will force the dropping of the leading 0. If the 0 is significant, then Text(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">NationalRegNumber) will preserve it in QV.</SPAN></SPAN></P></BODY></HTML> Tue, 07 Feb 2017 12:55:27 GMT jonathandienst 2017-02-07T12:55:27Z Problem with database load https://community.qlik.com/t5/QlikView/Problem-with-database-load/m-p/1228035#M622032 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>When I load data from an MYSQL database, QlikView adds a zero in the beginning of the value.</P><P>Example.</P><P></P><P><STRONG>Database</STRONG></P><P style="font-size: 13.3333330154419px;">Customer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NationalRegNumber</P><P style="font-size: 13.3333330154419px;">123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12345679</P><P></P><P><STRONG>QlikView</STRONG></P><P>Customer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NationalRegNumber</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 012345679</P><P></P><P>Do some of you have any idea why Qlikview does like this?</P><P>Thanks in advance</P><P>// Victor</P></BODY></HTML> Tue, 07 Feb 2017 12:36:41 GMT https://community.qlik.com/t5/QlikView/Problem-with-database-load/m-p/1228035#M622032 Anonymous 2017-02-07T12:36:41Z Re: Problem with database load https://community.qlik.com/t5/QlikView/Problem-with-database-load/m-p/1228036#M622033 <HTML><HEAD></HEAD><BODY><P>The first record loaded had a leading 0 in MySQL. QV uses this value to determine the format for the values of that field. If the value is a true number (ie the 0 is not needed), then Num(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">NationalRegNumber) will force the dropping of the leading 0. If the 0 is significant, then Text(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">NationalRegNumber) will preserve it in QV.</SPAN></SPAN></P></BODY></HTML> Tue, 07 Feb 2017 12:55:27 GMT https://community.qlik.com/t5/QlikView/Problem-with-database-load/m-p/1228036#M622033 jonathandienst 2017-02-07T12:55:27Z Re: Problem with database load https://community.qlik.com/t5/QlikView/Problem-with-database-load/m-p/1228037#M622034 <HTML><HEAD></HEAD><BODY><P>Thank you Jonathan, you saved my day!</P><P>Now it works! </P></BODY></HTML> Tue, 07 Feb 2017 14:26:08 GMT https://community.qlik.com/t5/QlikView/Problem-with-database-load/m-p/1228037#M622034 Anonymous 2017-02-07T14:26:08Z