Problem with big numbers (more than 14 digits)

[OmarBenSalem]

Hi guys ( stalwar1‌, hic‌ , petter-s‌ , mto  ..)

I have a problem to load BIG NUMBERS (more than 14,15 and even 17 digits).

In fact, when It's more than 14, Qlik can't seem to recognize the numbers as numbers anymore.

I've tried to surround the field by evaluate when loading it (evaluate(Field) instead of Field)

and this seemed to work at first sight. In fact, the numbers that were imported as Zero are now being well interpreted but then I've found out that there are still some numbers imported as 0 (even bigger numbers) ! So the Evaluate() doesn't seem to work for all the cases...

The question is: how can I import all the numbers (whatever how BIIIIIG they are), and still load them as numbers??)

ps: My source is REST; thus, I'd have to handle things within Qlik.

Thanks !

[sunny_talwar]

I think Ralf's formula is converting the number into text which is why I don't think you can sum it.... only thing I can think about is to divide the number for 1000 or 10000 may be...or may be hic can give you better idea.

[hic]

If you want all 16 digits, and treat it like text, you can load it as

   Text(Field)

but then you cannot use it as a number.

You can also load it using

  Dual(Field, Evaluate(Field))

Then you will get the original string (all 16 digits) as the textual value, and the evaluated string as numeric value. This works fine as long as you don't have two field values with identical 15 digits, but different 16th digit.

HIC

[simonaubert]

Hello,

Please note you can vote on this idea : https://community.qlik.com/t5/Ideas/Numeric-fields-on-Qlik-Sense-must-accept-more-than-14-digits/idi...

Best regards,

Simon