topic number in QlikView

number

johnan — Tue, 22 Sep 2009 18:46:18 GMT

I, i have a number:

00037350036211221

When a read in this in qv i'll get;

3,7350003625384e+017

What can i do?

number

Tue, 22 Sep 2009 18:50:21 GMT

Hi,

A numeric value can't have preceeding 0. it can be read as string ( use text() function). later on you can convert in number (use num() function).

Thanks & Best Regards,

Kuldeep Tak

number

johnan — Tue, 22 Sep 2009 19:41:20 GMT

Hi, i have in the script

text(myfield) as [mynumber]

But it' wont work

number

Tue, 22 Sep 2009 20:13:20 GMT

HI Johnan,

I believe that your field is too long. Numeric fields can have a length of around 14/15 and yours is longer. We came across this issue recently and our solution was to change the field to text in the source database instead of converting.

What it did in our case was cut of the field after position 14/15 and add 0 (zero's) to fill it up to the length of the original field. Therefore, we have moved around this by changing the source to text.

number

Tue, 22 Sep 2009 20:37:42 GMT

try using number formatting

num(myfield, '000000000000000000')

number

johnan — Tue, 22 Sep 2009 21:13:16 GMT

Hi all, its solved.
I'ts from DB2 and in the SQL i use DIGITS.