Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
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.

1 Reply
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.