topic Using where not exist in QlikView https://community.qlik.com/t5/QlikView/Using-where-not-exist/m-p/1250679#M620572 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P></P><P>How to find the differences in a column (similar) between 2 tables.</P><P></P><P>Example: There are 2 tables (Fact1 and Fact2), each containing a common field called "ID". I want to find out which values do not exist in Fact2.</P><P></P><P>Desired Result - "B" and "C"</P><P>I <IMG alt="Where not exists.png" class="jive-image image-1" src="/legacyfs/online/151120_Where not exists.png" style="font-size: 10pt; height: 555px; width: 620px;" /></P><P></P><P>Thanks,</P></BODY></HTML> Sat, 28 Jan 2017 21:59:46 GMT Anonymous 2017-01-28T21:59:46Z Using where not exist https://community.qlik.com/t5/QlikView/Using-where-not-exist/m-p/1250679#M620572 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P></P><P>How to find the differences in a column (similar) between 2 tables.</P><P></P><P>Example: There are 2 tables (Fact1 and Fact2), each containing a common field called "ID". I want to find out which values do not exist in Fact2.</P><P></P><P>Desired Result - "B" and "C"</P><P>I <IMG alt="Where not exists.png" class="jive-image image-1" src="/legacyfs/online/151120_Where not exists.png" style="font-size: 10pt; height: 555px; width: 620px;" /></P><P></P><P>Thanks,</P></BODY></HTML> Sat, 28 Jan 2017 21:59:46 GMT https://community.qlik.com/t5/QlikView/Using-where-not-exist/m-p/1250679#M620572 Anonymous 2017-01-28T21:59:46Z Re: Using where not exist https://community.qlik.com/t5/QlikView/Using-where-not-exist/m-p/1250680#M620573 <HTML><HEAD></HEAD><BODY><P>see your other thread regarding this topic:</P><P><A href="https://community.qlik.com/thread/247714">List difference / delta between 2 columns in 2 different tables in load script</A></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sat, 28 Jan 2017 23:43:11 GMT https://community.qlik.com/t5/QlikView/Using-where-not-exist/m-p/1250680#M620573 MarcoWedel 2017-01-28T23:43:11Z