topic Re: SQL EXCEPT in qlikview in QlikView https://community.qlik.com/t5/QlikView/SQL-EXCEPT-in-qlikview/m-p/559243#M208707 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>its same as NOT EXIST in qlikview </P></BODY></HTML> Tue, 24 Sep 2013 12:47:25 GMT Anonymous 2013-09-24T12:47:25Z SQL EXCEPT in qlikview https://community.qlik.com/t5/QlikView/SQL-EXCEPT-in-qlikview/m-p/559242#M208706 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have SQL query with Except statment.</P><P></P><P><SPAN class="pln">SELECT column1 </SPAN><SPAN class="pun">[,</SPAN><SPAN class="pln"> column2 </SPAN><SPAN class="pun">]</SPAN><SPAN class="pln"><BR />FROM table1 </SPAN><SPAN class="pun">[,</SPAN><SPAN class="pln"> table2 </SPAN><SPAN class="pun">]</SPAN><SPAN class="pln"><BR /></SPAN><SPAN class="pun">[</SPAN><SPAN class="pln">WHERE condition</SPAN><SPAN class="pun">]</SPAN><SPAN class="pln"><BR /><BR />EXCEPT<BR /><BR />SELECT column1 </SPAN><SPAN class="pun">[,</SPAN><SPAN class="pln"> column2 </SPAN><SPAN class="pun">]</SPAN><SPAN class="pln"><BR />FROM table1 </SPAN><SPAN class="pun">[,</SPAN><SPAN class="pln"> table2 </SPAN><SPAN class="pun">]</SPAN><SPAN class="pln"><BR /></SPAN><SPAN class="pun">[</SPAN><SPAN class="pln">WHERE condition</SPAN><SPAN class="pun">]</SPAN></P><P></P><P>I want to implement same in qlikview but dont know how to achieve..</P><P></P><P></P><P>I have 5 columns in both the table</P><P></P><P></P><P>Any help would be appreciated</P><P></P><P>Regards,</P><P>Kush</P></BODY></HTML> Tue, 24 Sep 2013 08:41:19 GMT https://community.qlik.com/t5/QlikView/SQL-EXCEPT-in-qlikview/m-p/559242#M208706 Kushal_Chawda 2013-09-24T08:41:19Z Re: SQL EXCEPT in qlikview https://community.qlik.com/t5/QlikView/SQL-EXCEPT-in-qlikview/m-p/559243#M208707 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>its same as NOT EXIST in qlikview </P></BODY></HTML> Tue, 24 Sep 2013 12:47:25 GMT https://community.qlik.com/t5/QlikView/SQL-EXCEPT-in-qlikview/m-p/559243#M208707 Anonymous 2013-09-24T12:47:25Z