topic Count Characters in QlikView https://community.qlik.com/t5/QlikView/Count-Characters/m-p/305461#M112809 <HTML><HEAD></HEAD><BODY><P>Try len(Codes) or len(trim(Codes)):</P><P></P><P>e.g. as list box field expression:</P><P>=if(len(Codes)=3,Codes)</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Tue, 21 Feb 2012 19:29:10 GMT swuehl 2012-02-21T19:29:10Z Count Characters https://community.qlik.com/t5/QlikView/Count-Characters/m-p/305460#M112808 <HTML><HEAD></HEAD><BODY><P>I have a field that is numeric and I need to only select the ones that have 3 numeric characters.&nbsp; How can I accomplish this?</P><P></P><P>What would the code be to flag the three digit elements?</P><P></P><P>If(Codes Character Count = 3, 'Three digit Flag', 'Other') AS [Digit Count],</P><P></P><P>Codes</P><P>02</P><P>03</P><P>04</P><P>111</P><P>222</P><P>333</P><P></P><P>Three digit Flag would return:</P><P>111</P><P>222</P><P>333</P><P></P><P>Other would return</P><P>02</P><P>03</P><P>04</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 21 Feb 2012 19:26:36 GMT https://community.qlik.com/t5/QlikView/Count-Characters/m-p/305460#M112808 2012-02-21T19:26:36Z Count Characters https://community.qlik.com/t5/QlikView/Count-Characters/m-p/305461#M112809 <HTML><HEAD></HEAD><BODY><P>Try len(Codes) or len(trim(Codes)):</P><P></P><P>e.g. as list box field expression:</P><P>=if(len(Codes)=3,Codes)</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Tue, 21 Feb 2012 19:29:10 GMT https://community.qlik.com/t5/QlikView/Count-Characters/m-p/305461#M112809 swuehl 2012-02-21T19:29:10Z Count Characters https://community.qlik.com/t5/QlikView/Count-Characters/m-p/305462#M112810 <HTML><HEAD></HEAD><BODY><P> Thanks swuehl, the Trim() solve my issue.&nbsp; </P></BODY></HTML> Tue, 21 Feb 2012 19:49:34 GMT https://community.qlik.com/t5/QlikView/Count-Characters/m-p/305462#M112810 2012-02-21T19:49:34Z Re: Count Characters https://community.qlik.com/t5/QlikView/Count-Characters/m-p/1660651#M448734 <P>Thank you</P> Thu, 26 Dec 2019 07:55:10 GMT https://community.qlik.com/t5/QlikView/Count-Characters/m-p/1660651#M448734 Johan_Kassing 2019-12-26T07:55:10Z