Counting values with specific sequence

[Vic13]

Hi everyone,

I am new to Qlikview and I am looking for guidance on how I can count the number of values in a field that meet a specific sequence.

The sequence that I am wanting to count is a combination of two letters followed by five numbers. (LL#####)

Any help is appreciated.

[Anil_Babu_Samineni · Accepted solution]

May be this?

Count(If(FieldName like 'LL?????', FieldName))

Or

Count({<FieldName = {"=Match(Len(FieldName)=7,'LL#####')"}>} FieldName)

Or

Count({<FieldName = {"=Match(FieldName,'LL#####')"}>} FieldName)