Count wildmatch

[awalhashim]

Hi all,

I want to count the field that contained the char which like this.

 Count(WildMatch(Interest.source, 'Non-'))

Is this the correct way to do because i have not use wildmatch function before and not sure how it is work.

Thanks by the way.

[sergioskv · Accepted solution]

HI!

It's much easier.

Try this:

Count({<Interest.source={"Non*"}>} Interest.source)

Sergio S.

[Thiago_Justen_]

Sergio gave you a better option, but you can also do this :

 Count(WildMatch(Interest.source, 'Non*'))

[sasis551]

Hi ,may be it works

load *,

if(wildmatch(Intrest.source,'Non-*'))as Filter   from location;

=>in text box you can take =>count(Filter)

[awalhashim]

Hi sergio, thanks for the reply. What if interest.source is actually an expression. It showing bad field name(s):. Thank u so much for your help.

[Thiago_Justen_]

You could also try this:

 Sum(If(WildMatch(Interest.source,'Non*'),1,0))