How to find a keyword with WildMatch in Qlik View?

[Matt_M1]

Hey All,

Rather than listing every variation of a particular assessment name, I'd like to use WildMatch but I cannot get it to work.  I'd like to find every assessment name that has 'log" in the name.  I've listed below what works for me right now:

=num(Count({<[VRT Overall Status] ={'In Progress'}, [Assessment Name] ={'Log4j2_Infrastructure', 'Wave_log4j', 'Log4j2_Infrastructure', 'Log4j_Infrastructure'} >}[Tracking ID]),'#,##0;-#,##0; ')

Thank you in advance for your assistance!!

Matt

[MarcoWedel · Accepted solution]

=num(Count({<[VRT Overall Status] ={'In Progress'}, [Assessment Name] ={"*log*"}>}[Tracking ID]),'#,##0;-#,##0; ')

[Matt_M1]

Worked like a dream!  Thanks so much!

[MarcoWedel · Accepted solution]

you're welcome. Glad it helped.