topic Re: Check if value is an integer in QlikView

Check if value is an integer

Thu, 07 Mar 2013 15:42:01 GMT

Hello,

Is it possible to check if a value is an integer when loading the data? I need to divide the number if it's not an integer and do nothing when the number is an integer.

Regards,

Johan

Re: Check if value is an integer

jagan — Thu, 07 Mar 2013 15:49:30 GMT

Hi,

Try like this

If(Len(PurgeChar(Value, '1234567890')) = 0, 'Integer', 'Non Integer')

Hope this helps you.

Regards,

Jagan.

Re: Check if value is an integer

CELAMBARASAN — Thu, 07 Mar 2013 15:52:00 GMT

You can simply use

Num(KeepChar(Value, '1234567890')) AS NumberField

Re: Check if value is an integer

Thu, 07 Mar 2013 16:48:26 GMT

I usually do something like this: if(myfield=round(myfield),'integer','not integer')

Re: Check if value is an integer

Fri, 08 Mar 2013 07:10:16 GMT

Thanks for all your suggestions. I tried if(frac(MyNum)=0 and it did the trick.