topic Re: exclude records in QlikView https://community.qlik.com/t5/QlikView/exclude-records/m-p/442906#M1151423 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use Where not exists(). Check it out in the F1 help.</P><P>Load Special, then load the Main where a key field does not exist in the special table and proceed to drop the special table I guess. Using Keep would be an option as well.</P></BODY></HTML> Thu, 11 Apr 2013 01:00:40 GMT Anonymous 2013-04-11T01:00:40Z exclude records https://community.qlik.com/t5/QlikView/exclude-records/m-p/442905#M1151422 <HTML><HEAD></HEAD><BODY><P>I have 2 qvds containing 2 lists: main &amp; special. Main includes special and non special list.</P><P></P><P>I want to look at data in non special.</P><P></P><P>normally in sql i would do a where statement. </P><P></P><P>where item not in (select item from special_list_table)</P><P></P><P>but how do i do this in qlikview?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 10 Apr 2013 20:31:25 GMT https://community.qlik.com/t5/QlikView/exclude-records/m-p/442905#M1151422 yelin_nyu 2013-04-10T20:31:25Z Re: exclude records https://community.qlik.com/t5/QlikView/exclude-records/m-p/442906#M1151423 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use Where not exists(). Check it out in the F1 help.</P><P>Load Special, then load the Main where a key field does not exist in the special table and proceed to drop the special table I guess. Using Keep would be an option as well.</P></BODY></HTML> Thu, 11 Apr 2013 01:00:40 GMT https://community.qlik.com/t5/QlikView/exclude-records/m-p/442906#M1151423 Anonymous 2013-04-11T01:00:40Z