decimal problem

[#1]

when im loading datas to qlikview from oracle database a specific column has decimal (15,2) in number data type . but in qlikview the decimal is not coming as same in the database .in 8.5 version

for :

ex:

in database value in that column is 0.50 and 0.75 and when it comes to qlikview it shows 0 and 0 after that decimal value its not showing

[#2]

Did you check your number format in properties?

[#3]

yup i have checked ... its fixed decimal 2 (#,##0.00) ... but its not coming

[#4]

priya any other idea ...... its urgent .....

[biester]

I've encountered a similar problem long time ago when still using ODBC for accessing the Oracle DB. I've not had this problem any more since I've been using OLEDB. If you're using ODBC, perhaps you should give it a try (actually, OLEDB should be preferred to ODBC as also performance usually is better).

Rgds,
Joachim

[#6]

thanks for ur answer... i have tried in OLEDB also its not working .....

[#7]

21440 Alternative number formatting makes decimals disappear

In 9 they say it is fixed.

[#8 · Accepted solution]

its wotking fine priya ... i just closed my application and opened again its working ... fine .. what fun.. it is.. any wy working thanks for ur helps