topic Re: Filter Email Help in QlikView

Filter Email Help

amit_saini — Tue, 31 Mar 2015 09:08:00 GMT

Hi Folks ,

I'm having data as per email ID's below:

I just want to filter my data based on my email Ids, want to see data only if email id is @abc.xyz.com

Please help!

Thanks,

renjithpl — Tue, 31 Mar 2015 09:18:32 GMT

May be this...

LOAD

Field
FROM
...
Where match(SubField(Field, '@', 2), 'abc.xyz.com')>0;

sagarkharpude — Tue, 31 Mar 2015 09:23:16 GMT

use wildmatch in script

if(wildmatch(email,'*@abc.xyz.com*')=1,1,0) as flag

and use this flag in front end

or you can also exclude the records while loading as below

load *

from Tablename where wildmatch(email,'*@abc.xyz.com*')=1;

Tue, 31 Mar 2015 09:26:32 GMT

hi,

use in where clause

Regards

Vimlesh

Tue, 31 Mar 2015 09:42:04 GMT

Hi,

Please try this:

load

from

where wildmatch(upper('abc@xyz.com'),'*@XYZ.COM')=1

Thanks!