Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Not a bug. That's the number of digits Qlik allows.
There's a request to increase it:
Not a bug. That's the number of digits Qlik allows.
There's a request to increase it: