topic 15 digit number in QlikView

15 digit number

mah_1356 — Tue, 22 Sep 2009 21:21:45 GMT

In my application there is a numeric field in the database which is so long that qlikview does not support it. Every number consists of 15 digits but, qlikview shows maximum 14 digits. I am using qlikview developer version 9.0. Does anybody know how to solve my problem?

Best regards

15 digit number

Anonymous — Tue, 22 Sep 2009 21:30:36 GMT

Not sure if it helps, but worth trying to use formatting like this:
num(Field, '###,###,###,###,###')

15 digit number

mah_1356 — Tue, 22 Sep 2009 22:00:39 GMT

thanks for your help but it did not help me.

infact, qlikview behaves this long number as a string.

Does anybody know an other soloution

15 digit number

Anonymous — Wed, 23 Sep 2009 01:18:49 GMT

You'll probably end up with splitting the string into two parts, perfroming separate calculations, and concatenate to long string again.
I wish I had a better idea.

15 digit number

GabrielAraya — Wed, 23 Sep 2009 03:51:12 GMT

Hi, QV support numeric data with a maximun of 14 digits, if the field has value with more than 14 digits QV evaluate the value as a text, could you test the following:

Load

Evaluate

(Campo) as CampoNum,

Campo;

LOAD

* INLINE [

Campo

1234567890123456789

]; The function EVALUATE() should convert the string value to numeric value.

Gabriel

15 digit number

johnan — Wed, 23 Sep 2009 14:13:29 GMT

Hi, if it is a DB2 you can use Select Digits(data) as data