Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Matt_M1
Contributor II
Contributor II

How to find a keyword with WildMatch in Qlik View?

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

2 Solutions

Accepted Solutions
MarcoWedel

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

View solution in original post

MarcoWedel

you're welcome. Glad it helped.

View solution in original post

3 Replies
MarcoWedel

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

Worked like a dream!  Thanks so much!

MarcoWedel

you're welcome. Glad it helped.