topic Re: How to remove trailing zeroes? in QlikView

How to remove trailing zeroes?

Mon, 21 Dec 2015 22:37:04 GMT

I'm pulling data from Oracle and I'm getting this weird scenario. I'm pulling a field that is of NUMBER data type in Oracle and yes I've made certain it's a NUMBER data type. The value in Oracle is 29.94. When I run it on my local machine, I get the attached result (note it's not all zeroes, there's a "1" as well.

I can suppress the zeroes by changing it on the Number tab in the object's properties but this is not what I want. If I go to Table Viewer and preview the data, it is still showing the zeroes.

I reloaded this same qvw on one of our dev servers and it displays the correct value in the object and Table Viewer. This data set is huge so getting rid of these trailing zeroes would be extremely beneficial. I have tried the CAST and TRUNC functions in the SQL select to no avail.

I can only think it's either a Qlikview or system setting that's causing the zeroes on my machine and not the dev server.

Thanks

Re: How to remove trailing zeroes?

swuehl — Mon, 21 Dec 2015 23:23:56 GMT

Maybe similar to shown here

Re: Loading using Oracle OLEDB-Error reading number format

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Re: How to remove trailing zeroes?

Mon, 21 Dec 2015 23:58:38 GMT

Thanks, the cause was in Oracle db the column's data type is NUMBER but precision and scale are not defined. I cannot make changes to the db.

Other than performing Num or Floor functions, is there an alternative? Seems like there could be difference in Oracle drivers since it's fine on the dev server.

Re: How to remove trailing zeroes?

swuehl — Tue, 22 Dec 2015 00:22:13 GMT

In the referenced threads, it's mentioned that Microsoft OLEDB provider for Oracle is working without that issue.

Re: How to remove trailing zeroes?

Tue, 22 Dec 2015 16:01:54 GMT

Thanks for the reply.

That does not appear to work. And it does not explain why I get the zeroes on my local machine but if I reload on the dev server it is fine.

Re: How to remove trailing zeroes?

swuehl — Wed, 23 Dec 2015 00:05:28 GMT

Since there is not much information published about the difference between your local machine and the dev server, I think I can't help here.