topic Re: Re: Removing useless zero in number in QlikView

Removing useless zero in number

Wed, 21 Aug 2013 08:01:12 GMT

Hi everybody

I have a problem in qv server 11! I have a lot of number(both of real and float) in a qv document. but when I reload, I see a lot of zero after the real number! for example I have a field that contains 800,801,802,............. after ending reloading process, the listbox of that display:

800.000000000000000000000000000000000000000000000000000000000000000000000000000

801.000000000000000000000000000000000000000000000000000000000000000000000000000

802.000000000000000000000000000000000000000000000000000000000000000000000000000

Please consider that the number of these kind of fields are not a few and the length of the numbers are different(for example I have 1,800,9241,... in a specified field) and I can't use the function to_char(fieldname,format) for all of them in a similar way! I need a total solution for solving this problem like a set format in one line statement in script that doesn't affect the flaot numbers. I tried changing format in number tab for these fields, but unfortunately after reloading the app, the problem will appear again!

Regards

Reihaneh

Re: Removing useless zero in number

sparur — Wed, 21 Aug 2013 08:08:45 GMT

very strange behaviour )

could you provide example of qvw?

Anyway, try to use Num() function for formatting in the script.

Re: Re: Removing useless zero in number

Wed, 21 Aug 2013 10:02:11 GMT

Yeah I think so! I didn't have this kind of problem at previous versions

Re: Removing useless zero in number

rbecher — Wed, 21 Aug 2013 10:11:29 GMT

Hi,

there was a long thread in the past about this issue:

Re: use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

If this is related to a Oracle number type with unspecified precision and scale you could use a CAST:

SELECT cast(COLUMN1 as number(38)) as COLUMN1,

or by using num#( ) function in QlikView.

- Ralf

Re: Removing useless zero in number

er_mohit — Wed, 21 Aug 2013 10:16:14 GMT

try this function

left(fieldname,(Index(fieldname,'.')-1) as Fieldname

Try this in your script

LOAD

Left(F1,Index(F1,'.')-1)as F1;

LOAD * INLINE [

1.000000

2.000000

800.0000000000

801.000000000000

];

Re: Re: Removing useless zero in number

Wed, 21 Aug 2013 10:37:22 GMT

Thank you a lot. It's so helpful but I will want to know if a solution exists to apply for all fields just in one line statement, like a set format at first of code. Cast function should be applied one by one for numeric fields.

Regards

Reihaneh

Re: Removing useless zero in number

Wed, 21 Aug 2013 10:40:57 GMT

try simple like this

num(fieldname)

**************************************************

LOAD *, num(x) as num

Inline [

2.00000

11.0230000000

5.23000000000

];

Re: Removing useless zero in number

nizamsha — Wed, 21 Aug 2013 10:48:20 GMT

Table:

LOAD * Inline [

sales

1.0000

2.0000

3.0000

12345.00000000000000000000000000

123456.00000000000000000000000000

2345678555000,000000000000000000

];

table2:

LOAD

num( sales ,'#,##0') as sales1

Resident Table;

Re: Removing useless zero in number

Mon, 31 Jul 2017 13:54:42 GMT

Hi,

Did you get any permanent solution for this problem. Please let me know, I am facing the same kind of issue