Discussion Board for collaboration related to QlikView App Development.
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', ','))
Go to Solution.
=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.