
Contributor II
2022-04-12
06:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
IsNum, Num and Num# fail to recognize a big number with at least 15 digit
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?
374 Views
1 Solution
Accepted Solutions


MVP
2022-04-12
07:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not a bug. That's the number of digits Qlik allows.
There's a request to increase it:
1 Reply


MVP
2022-04-12
07:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not a bug. That's the number of digits Qlik allows.
There's a request to increase it:
