Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
In the Oracle database, i have a fields type Number(), when i converted this field to qlikview field, the conversion resulted some problems.
Ex: Num(Field Oracle) as Field Qlikview
Oracle field | Qlikview field result |
---|---|
521,00 | 521,00000000002153 |
342,13 | 342,13000000000000 |
95,62 | 95,61999999999999 |
OBS: coma is a decimal point
I try: Money(Field Oracle), Num(Left(Text(Num(Field Oracle)), Index(Text(Num(Field Oracle)), ',') + 2)... and others, but the problem persist.
Oracle version: 11g Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production "CORE 11.2.0.4.0 Production"
TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production
Qlikview version: 11.20.11922.0 SR2 64-bit Edition (x64)
Can anyone help me?
Massimo, unfortunately I can't change the fields.
Have you tried forcing the format such as MONEY(FIELDNAME,'€#.###,00')?
James I've tested it, and the result was the same.
trying changing the connection string ODBC/OLEDB may help you. I did not remember the exact driver but if you are using ODBC please try OLEDB or vice versa.
Emre I using ODBC connection and I change by OLEDB like your suggestion, the problem persist.
Oracle drive version: SQORA32.dll 11.02.00.03
thanks
Hi!
I tried various ways and only got hit when I changed the number format by Oracle. Like this:
TO_CHAR (FIELD, '000000000000000D00 ') AS FieldChanged
Return a string that was '000000000000000 .00 ', in my country the decimal separator is a comma.
So in QV simple character substitution converted the number correctly.
Replace (FieldChanged, '.', ',')
Thanks.