topic Not Like in Set Analysis in QlikView

Not Like in Set Analysis

Anonymous — Tue, 09 May 2017 18:52:04 GMT

I want to only count records where the email is NOT LIKE @gmail.com, but I cannot figure out the set analysis ... This is what I have come up with so far. .

=count({<WhoEmail NOT LIKE WildMatch(WhoEmail,'*gmail*')>}distinct(WhoId))

Any help is appreciated!!! Thank you

- dave

Re: Not Like in Set Analysis

sunny_talwar — Tue, 09 May 2017 18:54:37 GMT

May be this

=Count({<WhoEmail -= {'*gmail*'}>} DISTINCT WhoId)

Re: Not Like in Set Analysis

Anonymous — Tue, 09 May 2017 18:58:07 GMT

what about null() for WhoEMail?!?

Do you like to "include" it or not...?

Re: Not Like in Set Analysis

neelamsaroha157 — Tue, 09 May 2017 18:58:57 GMT

Try thi

Count({$<Mail -={"*$(='*gmail*')*"}>}Mail)

Count({$<WhoEmail -={"*$(='*gmail*')*"}>}distinct WhoId)