topic Re: How to Like function? in QlikView

How to Like function?

Anonymous — Mon, 07 Aug 2017 20:06:25 GMT

Hi,

I have a field with emails, the idea is to have the sum of views that the users are making to some documents.

But I will like to exclude the emails that are like '@gmail.com' for example.

Actually I am summing everything but will like to sum all except for the gmail accounts.

How can I do that?

vishsaggi — Mon, 07 Aug 2017 20:19:58 GMT

May be like Not WildMatch() function. Can you explain a little more if below is not what you are expecting?

IF(Not WildMatch(YourfieldName, '*@*'), 1, 0) As yourNewField

krishnacbe — Mon, 07 Aug 2017 20:22:20 GMT

May be like this

=if(SubStringCount(Email,'gmail')=1,0,Count(ID))

Anonymous — Mon, 07 Aug 2017 20:23:10 GMT

I need to use it in an expression, how can I put it there?

vishsaggi — Mon, 07 Aug 2017 20:46:47 GMT

May be this?

= Sum(IF(Not WildMatch(YourfieldName, '*@*'), 1, 0))

effinty2112 — Mon, 07 Aug 2017 21:17:54 GMT

Hi Roberto,

Maybe something like:

Count({$<email -={'*gmail.com'}>}ViewID)

You will need to change email and ViewID to the fieldnames you are actually using.

Regards

Andrew

Kushal_Chawda — Tue, 08 Aug 2017 10:06:16 GMT

Create the flag in script

LOAD *,

if(wildmatch(lower(Email),'*@gmail.com*',1,0) as EmailFlag

FROM Table;

Now you can write the expression in chart like below

=count({<EmailFlag={0}>} ID)

Anonymous — Tue, 08 Aug 2017 13:30:42 GMT

This is what I needed, thank you

effinty2112 — Tue, 08 Aug 2017 15:13:19 GMT

Hi Roberto,

Glad to help!!