Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
When I load data from an MYSQL database, QlikView adds a zero in the beginning of the value.
Example.
Database
Customer NationalRegNumber
123 12345679
QlikView
Customer NationalRegNumber
123 012345679
Do some of you have any idea why Qlikview does like this?
Thanks in advance
// Victor
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(NationalRegNumber) will force the dropping of the leading 0. If the 0 is significant, then Text(NationalRegNumber) will preserve it in QV.
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(NationalRegNumber) will force the dropping of the leading 0. If the 0 is significant, then Text(NationalRegNumber) will preserve it in QV.
Thank you Jonathan, you saved my day!
Now it works!