https://community.qlik.com/t5/QlikView/where-clause/m-p/1663200#M594983 <P>Try:</P><LI-CODE lang="markup">text(as_at_date) &lt;&gt; '30-jun-2018' and name &lt;&gt; 'abc' and s_name &lt;&gt; 'group'</LI-CODE> Tue, 07 Jan 2020 08:49:27 GMT Arthur_Fong 2020-01-07T08:49:27Z https://community.qlik.com/t5/QlikView/where-clause/m-p/1663184#M594982 <P>i have this script&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">select * from where as_at_date &lt;&gt; date('30-jun-2018') and name &lt;&gt; 'abc' and s_name &lt;&gt; 'group'</LI-CODE><P>&nbsp;</P><P>i dont want data only for 30-jun-2018 against name 'abc'</P><P>&nbsp;i did this but this is not working&nbsp;</P> Tue, 07 Jan 2020 07:31:44 GMT https://community.qlik.com/t5/QlikView/where-clause/m-p/1663184#M594982 capriconuser 2020-01-07T07:31:44Z https://community.qlik.com/t5/QlikView/where-clause/m-p/1663200#M594983 <P>Try:</P><LI-CODE lang="markup">text(as_at_date) &lt;&gt; '30-jun-2018' and name &lt;&gt; 'abc' and s_name &lt;&gt; 'group'</LI-CODE> Tue, 07 Jan 2020 08:49:27 GMT https://community.qlik.com/t5/QlikView/where-clause/m-p/1663200#M594983 Arthur_Fong 2020-01-07T08:49:27Z https://community.qlik.com/t5/QlikView/where-clause/m-p/1663207#M594984 <P>Can you explain how it's not working?</P><P>What is the source data, the result you now get and the result you want to get?</P> Tue, 07 Jan 2020 09:04:49 GMT https://community.qlik.com/t5/QlikView/where-clause/m-p/1663207#M594984 Gysbert_Wassenaar 2020-01-07T09:04:49Z