Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to Like function?

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?

1 Solution

Accepted Solutions
effinty2112
Master
Master

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

View solution in original post

8 Replies
vishsaggi
Champion III
Champion III

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
Partner - Specialist III
Partner - Specialist III

May be like this

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

Anonymous
Not applicable
Author

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

vishsaggi
Champion III
Champion III

May be this?

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

effinty2112
Master
Master

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

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
Not applicable
Author

This is what I needed, thank you

effinty2112
Master
Master

Hi Roberto,

Glad to help!!