topic decimal problem in QlikView

decimal problem

Tue, 15 Jun 2010 07:17:40 GMT

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

decimal problem

Tue, 15 Jun 2010 07:20:46 GMT

Did you check your number format in properties?

decimal problem

Tue, 15 Jun 2010 07:22:42 GMT

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

decimal problem

Tue, 15 Jun 2010 07:27:48 GMT

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

AW:Re: decimal problem

biester — Tue, 15 Jun 2010 07:39:23 GMT

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

AW:Re: decimal problem

Tue, 15 Jun 2010 07:46:02 GMT

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

decimal problem

Tue, 15 Jun 2010 07:56:54 GMT

21440 Alternative number formatting makes decimals disappear

In 9 they say it is fixed.

decimal problem

Tue, 15 Jun 2010 08:06:58 GMT

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