15 digit number

[mah_1356]

Hi

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

[Anonymous]

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

[mah_1356]

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

[Anonymous]

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.

[GabrielAraya]

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

[johnan]

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