largest integer authorized ? still 15 digits?

[simonaubert]

Hello Everyone,

I had in mind that integers on qlik would be limited on 15 digits since 2019 (14 before).

What is the largest numeric value that can be load... - Qlik Community - 1744936
Re: Problem with big numbers (more than 14 digits) - Page 2 - Qlik Community - 36929

However, i just connected my Qlik Sense server to a bigquery table with 17-20 integers (obtained with farm_fingerprint for keys).
And... it seems to work !!

What did I miss? 

Best regards,

Simon

[Or]

Are you sure it worked? That all of these numbers are exactly 17 digits long when removing trailing zeroes seems pretty suspect considering the actual length of the values isn't identical...

[marcus_sommer]

In addition to @Or do a few calculations with these numbers to find possible differences between storing the data and their meta-information and the capabilities of the engine to calculate with them.

Background are my very early experiences with QV which could treat a 15-digit number as number, for example in keys/joins but not calculating with them.

[simonaubert]

@marcus_sommer  and @Or  Thanks. 
I'm sure it seems to work... not sure it works perfectly fine.

I tested the sum, multiplication abd addition, worked pretty well

[Or · Accepted solution]

But are these the actual underlying numbers? And, do they all have no significant digits past a certain number? Qlik has no issue saving numbers larger than 15 digits - but only the most significant digits are saved. That's why I mentioned that the trailing zeroes are suspect. 

[simonaubert]

@Or good catchn thanks !! The trailing 0 shouldn't exist.. and that also explain i guess that a +1 does not work

[Or]

Luckily, we can still fix this with text() 🙂