topic Re: IsNum, Num and Num# fail to recognize a big number with at least 15 digit in App Development

IsNum, Num and Num# fail to recognize a big number with at least 15 digit

Carlo_Romagnano — Tue, 12 Apr 2022 10:58:22 GMT

With 15 or more digits IsNum('000000000425510') returns false, with 14 digit IsNum('00000000425510') returns true.

It's a bug?

Here my temporary solution:
IsNum(replace(ltrim(replace('000000000425510','0',' ')),' ','0'))

Is there a better solution?

Or — Tue, 12 Apr 2022 11:01:58 GMT

Not a bug. That's the number of digits Qlik allows.

There's a request to increase it: