Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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-...