topic Re: Count wildmatch in QlikView

Count wildmatch

awalhashim — Sat, 16 Nov 2024 05:12:23 GMT

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 — Mon, 19 Nov 2018 10:36:58 GMT

HI!

It's much easier.

Try this:

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

Sergio S.

Thiago_Justen_ — Mon, 19 Nov 2018 10:39:06 GMT

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

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

sasis551 — Mon, 19 Nov 2018 10:39:38 GMT

Hi ,may be it works

load *,

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

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

awalhashim — Mon, 19 Nov 2018 12:24:54 GMT

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_ — Mon, 19 Nov 2018 12:35:59 GMT

You could also try this:

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