topic Re: How can i know if a field contains only numeric values ? in Water Cooler https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742856#M3463 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use the below script in script level or in Chart.</P><P></P><P>1. if(Isnum(FieldName),'Num','Text')</P><P></P><P>or</P><P></P><P>2. <SPAN style="font-size: 13.3333339691162px;"> if(IsText(FieldName),'Text','Num')</SPAN></P><P></P><P>Regards,</P><P>Joshmi</P></BODY></HTML> Fri, 28 Nov 2014 12:25:08 GMT 2014-11-28T12:25:08Z How can i know if a field contains only numeric values ? https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742852#M3459 <HTML><HEAD></HEAD><BODY><P>I have a problem: i must know if a alphanumeric field contains only numeric value or not.</P><P>Please help me</P><P>Thanks</P><P>Claudio</P></BODY></HTML> Fri, 28 Nov 2014 11:50:19 GMT https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742852#M3459 2014-11-28T11:50:19Z Re: How can i know if a field contains only numeric values ? https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742853#M3460 <HTML><HEAD></HEAD><BODY><P>Add a Statistics Box object for the field and add the Numeric Count and Text Count statistics. Then check those counts.</P></BODY></HTML> Fri, 28 Nov 2014 11:55:39 GMT https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742853#M3460 Gysbert_Wassenaar 2014-11-28T11:55:39Z Re: How can i know if a field contains only numeric values ? https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742854#M3461 <HTML><HEAD></HEAD><BODY><P>try to work with purgechar</P><P>you may convert your field to upper case string</P><P></P><P> if (purgechar(yourstring,'0123456789ABCDEF')='',1,0)</P><P>1: only alphanumeric</P><P>0: other characters</P></BODY></HTML> Fri, 28 Nov 2014 12:15:46 GMT https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742854#M3461 Anonymous 2014-11-28T12:15:46Z Re: How can i know if a field contains only numeric values ? https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742855#M3462 <HTML><HEAD></HEAD><BODY><P>Hi try this</P><H4><SPAN class="Bold"><A name="kanchor811"></A>IsNum<A name="kanchor812"></A><A name="IsNum"></A>( </SPAN><SPAN style="font-style: italic;">expr</SPAN><SPAN class="Bold"> )</SPAN> </H4><P>Returns -1 (true) if the expression can be interpreted as a number, otherwise 0 (false).</P><P>Regards</P><P>Harsha</P></BODY></HTML> Fri, 28 Nov 2014 12:20:03 GMT https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742855#M3462 Anonymous 2014-11-28T12:20:03Z Re: How can i know if a field contains only numeric values ? https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742856#M3463 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use the below script in script level or in Chart.</P><P></P><P>1. if(Isnum(FieldName),'Num','Text')</P><P></P><P>or</P><P></P><P>2. <SPAN style="font-size: 13.3333339691162px;"> if(IsText(FieldName),'Text','Num')</SPAN></P><P></P><P>Regards,</P><P>Joshmi</P></BODY></HTML> Fri, 28 Nov 2014 12:25:08 GMT https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742856#M3463 2014-11-28T12:25:08Z Re: How can i know if a field contains only numeric values ? https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742857#M3464 <HTML><HEAD></HEAD><BODY><P>Ok, I use the first:</P><P>=IF (IsNum( Warehouse_Map.DS_COLUMN),right('000' &amp; Warehouse_Map.DS_COLUMN,3),Warehouse_Map.DS_COLUMN)</P><P>Thanks,</P><P>Claudio</P></BODY></HTML> Fri, 28 Nov 2014 13:01:54 GMT https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742857#M3464 2014-11-28T13:01:54Z Re: How can i know if a field contains only numeric values ? https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742858#M3465 <HTML><HEAD></HEAD><BODY><P>Hi Claudio,</P><P></P><P>Could you close this discussion , if you find the same as helpful&nbsp; or correct.</P><P></P><P>Regards,</P><P>Joshmi</P></BODY></HTML> Fri, 28 Nov 2014 13:07:41 GMT https://community.qlik.com/t5/Water-Cooler/How-can-i-know-if-a-field-contains-only-numeric-values/m-p/742858#M3465 2014-11-28T13:07:41Z