https://community.qlik.com/t5/QlikView/Counting-values-with-specific-sequence/m-p/1681170#M726548 <P>May be this?</P><P><STRONG>Count(If(FieldName like 'LL?????', FieldName))</STRONG></P><P><STRONG>Or</STRONG></P><P><STRONG>Count({&lt;FieldName = {"=Match(Len(FieldName)=7,'LL#####')"}&gt;} FieldName)</STRONG></P><P><STRONG>Or</STRONG></P><P><STRONG>Count({&lt;FieldName = {"=Match(FieldName,'LL#####')"}&gt;} FieldName)</STRONG></P> Tue, 03 Mar 2020 08:13:34 GMT Anil_Babu_Samineni 2020-03-03T08:13:34Z https://community.qlik.com/t5/QlikView/Counting-values-with-specific-sequence/m-p/1680957#M726547 <P>Hi everyone,</P><P>I am new to Qlikview and I am&nbsp;looking for guidance on how I can&nbsp;count the number of values in a field that meet a specific sequence.</P><P>The sequence that I am wanting to count is a combination of two letters followed by five numbers. (LL#####)</P><P>Any help is appreciated.</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Counting-values-with-specific-sequence/m-p/1680957#M726547 Vic13 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Counting-values-with-specific-sequence/m-p/1681170#M726548 <P>May be this?</P><P><STRONG>Count(If(FieldName like 'LL?????', FieldName))</STRONG></P><P><STRONG>Or</STRONG></P><P><STRONG>Count({&lt;FieldName = {"=Match(Len(FieldName)=7,'LL#####')"}&gt;} FieldName)</STRONG></P><P><STRONG>Or</STRONG></P><P><STRONG>Count({&lt;FieldName = {"=Match(FieldName,'LL#####')"}&gt;} FieldName)</STRONG></P> Tue, 03 Mar 2020 08:13:34 GMT https://community.qlik.com/t5/QlikView/Counting-values-with-specific-sequence/m-p/1681170#M726548 Anil_Babu_Samineni 2020-03-03T08:13:34Z