Trobles Converting fields (Oracle) for to Qlikview

[MarcoARaymundo]

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?

[MarcoARaymundo]

Massimo, unfortunately I can't change the fields.

[ThornOfCrowns]

Have you tried forcing the format such as MONEY(FIELDNAME,'€#.###,00')?

[MarcoARaymundo]

James I've tested it, and the result was the same.

[ordre]

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.

[MarcoARaymundo]

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

[MarcoARaymundo · Accepted solution]

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.