https://community.qlik.com/t5/QlikView/Where-Exists/m-p/1532908#M747018 <P>Function EXISTS refers to data reloaded <U>before</U> this table. Please use: <STRONG>where&nbsp;len(trim(Email))&gt;0</STRONG> or<STRONG> where not isnull(Email)</STRONG></P> Mon, 21 Jan 2019 20:53:04 GMT Jacek 2019-01-21T20:53:04Z https://community.qlik.com/t5/QlikView/Where-Exists/m-p/1532900#M747016 <P>Hi All,</P><P>&nbsp;</P><P>From the attached file,&nbsp; I only want to show record that have an email address.</P><P>I am using where Exists function and is not working. I am still getting records with doesn't have email address.</P><P>Any help would be really appreciate it&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Where-Exists/m-p/1532900#M747016 has75042 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Where-Exists/m-p/1532904#M747017 <P>Try:</P><P>where len(Email)&gt;0</P> Mon, 21 Jan 2019 19:57:56 GMT https://community.qlik.com/t5/QlikView/Where-Exists/m-p/1532904#M747017 m_woolf 2019-01-21T19:57:56Z https://community.qlik.com/t5/QlikView/Where-Exists/m-p/1532908#M747018 <P>Function EXISTS refers to data reloaded <U>before</U> this table. Please use: <STRONG>where&nbsp;len(trim(Email))&gt;0</STRONG> or<STRONG> where not isnull(Email)</STRONG></P> Mon, 21 Jan 2019 20:53:04 GMT https://community.qlik.com/t5/QlikView/Where-Exists/m-p/1532908#M747018 Jacek 2019-01-21T20:53:04Z