isnum() expression not recognizing large number as a number

[mp802377]

I need to identify the data that contains a number in the 'Field' column. I put the if statement in the editor. If it sees a number < 10, it picks it up as Numeric. If the number is huge, like 311521470029562, it looks at it like as Alphanumeric (based on the if statement). Why does the ifnum() not working for larger numbers?

if(isnum(FieldInQuestion), 'Numeric', 'Alphanumeric') as Field,

[Kushal_Chawda · Accepted solution]

@mp802377  Qlik interprets number only up to 14 digits.  In your case digits are 15 which is why it is interpreted as text.

If you want to show it as Numeric, you need to tweak the condition like below

if(isnum(FieldInQuestion) or KeepChar(FieldInQuestion,'0123456789')=FieldInQuestion, 'Numeric', 'Alphanumeric') as Field

[edwin]

read it here:

https://community.qlik.com/t5/Official-Support-Articles/What-is-the-largest-numeric-value-that-can-b...

so try 

IsNum(evaluate(field))