Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlo_Romagnano
Contributor II
Contributor II

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?

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

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

There's a request to increase it:

https://community.qlik.com/t5/Suggest-an-Idea/Numeric-fields-on-Qlik-Sense-must-accept-more-than-14-...

 

View solution in original post

1 Reply
Or
MVP
MVP

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

There's a request to increase it:

https://community.qlik.com/t5/Suggest-an-Idea/Numeric-fields-on-Qlik-Sense-must-accept-more-than-14-...