Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)