Count if Contains Specific Letters

[hammermill21]

HELLO,

I'm trying to get a count of a standard that contains the letters EC in there.

I have a list of standards that have data like:

EC.02.05.03

EC.02.05.03

EC.02.05.03

EM.02.05.03

LC.02.05.03

So I'm trying to count how many start with EC and everything I've tried doesn't work.

I tried the following:

IF(INDEX(STANDARD,'EC')>0

COUNT(IF(STANDARD='EC',STANDARD))

if(trim(STANDARD)='EC'

Nothing seems to work

[sunny_talwar · Accepted solution]

Try this

Count({<STANDARD = {"EC*"}>}STANDARD)

[sunny_talwar]

Or this

Count(If(WildMatch(STANDARD, 'EC*'), STANDARD))

[petter]

If( STANDARD Like 'EC*' , ...... )

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/Operators/StringOper...‌

or

Count( {<STANDARD={'EC*'}>} STANDARD)

[hammermill21]

Thank you for the link!