topic Re: comparing string to email field in QlikView https://community.qlik.com/t5/QlikView/comparing-string-to-email-field/m-p/1198113#M883590 <HTML><HEAD></HEAD><BODY><P>thats great, thanks for your help Stefan. its the '*'&amp;FirstName&amp;'*' that i couldnt get right! </P><P>obvious now!</P></BODY></HTML> Mon, 03 Oct 2016 13:06:23 GMT hopkinsc 2016-10-03T13:06:23Z comparing string to email field https://community.qlik.com/t5/QlikView/comparing-string-to-email-field/m-p/1198111#M883588 <HTML><HEAD></HEAD><BODY><P>hi all. i am trying to compare a 'FirstName' field to an 'Email' field in a chart. </P><P>all i want to do is to check if the email field contains the first name but i cant get this to work.</P><P>does anyone have any ideas please?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/comparing-string-to-email-field/m-p/1198111#M883588 hopkinsc 2020-11-25T16:16:04Z Re: comparing string to email field https://community.qlik.com/t5/QlikView/comparing-string-to-email-field/m-p/1198112#M883589 <HTML><HEAD></HEAD><BODY><P>Maybe something like</P><P></P><P>=Sum( If( Email LIKE '*'&amp;FirstName&amp;'*', 1,0))</P><P></P><P>Or use other string comparison functions like&nbsp; Wildmatch().</P><P></P><P>But it's hard to suggest anything specific without knowing the context you want to use it (data model, chart dimensions / expressions etc.)</P></BODY></HTML> Mon, 03 Oct 2016 13:03:13 GMT https://community.qlik.com/t5/QlikView/comparing-string-to-email-field/m-p/1198112#M883589 swuehl 2016-10-03T13:03:13Z Re: comparing string to email field https://community.qlik.com/t5/QlikView/comparing-string-to-email-field/m-p/1198113#M883590 <HTML><HEAD></HEAD><BODY><P>thats great, thanks for your help Stefan. its the '*'&amp;FirstName&amp;'*' that i couldnt get right! </P><P>obvious now!</P></BODY></HTML> Mon, 03 Oct 2016 13:06:23 GMT https://community.qlik.com/t5/QlikView/comparing-string-to-email-field/m-p/1198113#M883590 hopkinsc 2016-10-03T13:06:23Z