topic Re: isnum() expression not recognizing large number as a number in App Development

isnum() expression not recognizing large number as a number

mp802377 — Mon, 24 Apr 2023 18:51:40 GMT

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,

Re: isnum() expression not recognizing large number as a number

Kushal_Chawda — Mon, 24 Apr 2023 20:48:15 GMT

@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

Re: isnum() expression not recognizing large number as a number

edwin — Mon, 24 Apr 2023 20:53:51 GMT

read it here:

https://community.qlik.com/t5/Official-Support-Articles/What-is-the-largest-numeric-value-that-can-be-loaded-in-Qlik/ta-p/1744936

so try

IsNum(evaluate(field))