topic Re: Check for Numbers in QlikView https://community.qlik.com/t5/QlikView/Check-for-Numbers/m-p/919691#M318751 <HTML><HEAD></HEAD><BODY><P>IsNum(Left(YourField,4))</P><P>or,</P><P>IsNum(SubField(YourField,'-',1))</P></BODY></HTML> Wed, 29 Jul 2015 10:19:17 GMT tresB 2015-07-29T10:19:17Z Check for Numbers https://community.qlik.com/t5/QlikView/Check-for-Numbers/m-p/919690#M318750 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a field with 0043-APT-XYZ-DW.</P><P></P><P>The first 4 elements shows the project name.</P><P></P><P>How to check whether the first 4 elements are number?</P><P></P><P>Regards,</P><P>Keerthi KS</P></BODY></HTML> Wed, 29 Jul 2015 10:13:42 GMT https://community.qlik.com/t5/QlikView/Check-for-Numbers/m-p/919690#M318750 2015-07-29T10:13:42Z Re: Check for Numbers https://community.qlik.com/t5/QlikView/Check-for-Numbers/m-p/919691#M318751 <HTML><HEAD></HEAD><BODY><P>IsNum(Left(YourField,4))</P><P>or,</P><P>IsNum(SubField(YourField,'-',1))</P></BODY></HTML> Wed, 29 Jul 2015 10:19:17 GMT https://community.qlik.com/t5/QlikView/Check-for-Numbers/m-p/919691#M318751 tresB 2015-07-29T10:19:17Z Re: Check for Numbers https://community.qlik.com/t5/QlikView/Check-for-Numbers/m-p/919692#M318752 <HTML><HEAD></HEAD><BODY><P>try like this using subfield function :</P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>IsNum(SubField(FieldName,'-',1))</STRONG></SPAN></P></BODY></HTML> Wed, 29 Jul 2015 10:23:41 GMT https://community.qlik.com/t5/QlikView/Check-for-Numbers/m-p/919692#M318752 avinashelite 2015-07-29T10:23:41Z Re: Check for Numbers https://community.qlik.com/t5/QlikView/Check-for-Numbers/m-p/919693#M318753 <HTML><HEAD></HEAD><BODY><P>if( isnum(subfield(Field,'-',1)), expression1, expression)</P></BODY></HTML> Wed, 29 Jul 2015 10:26:15 GMT https://community.qlik.com/t5/QlikView/Check-for-Numbers/m-p/919693#M318753 Kushal_Chawda 2015-07-29T10:26:15Z