Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

counting if condition is met

I am trying to add number of subtypes if it contains a certain value, like "Noise" or "Animal" etc.

I've used the following expressions, but did not work

=Num(COUNT(WILDMATCH(SUBTYPE, 'NOISE')),'#,##0', ',')

//=IF(WILDMATCH(SUBTYPE, '*NOISE*'), NUM(COUNT(SUBTYPE),'#,##0', ','))

//=NUM(COUNT(wildMatch(text, ‘*Noise*’)))

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: counting if condition is met

Try

=Sum( Wildmatch(SUBTYPE, '*NOISE*') )

//Wildmatch returns zero if there is no match and 1 if the value is like '*NOISE*'

It would also be helpful to know the context of the expression.

View solution in original post

1 Reply
Highlighted
MVP
MVP

Re: counting if condition is met

Try

=Sum( Wildmatch(SUBTYPE, '*NOISE*') )

//Wildmatch returns zero if there is no match and 1 if the value is like '*NOISE*'

It would also be helpful to know the context of the expression.

View solution in original post