topic Unmatched values problem in QlikView https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607012#M682300 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to display unmatched field values from second table where in first table they are present which function should I use?Lookup or applymap?</P></BODY></HTML> Thu, 06 Mar 2014 04:55:24 GMT vijetas42 2014-03-06T04:55:24Z Unmatched values problem https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607012#M682300 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to display unmatched field values from second table where in first table they are present which function should I use?Lookup or applymap?</P></BODY></HTML> Thu, 06 Mar 2014 04:55:24 GMT https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607012#M682300 vijetas42 2014-03-06T04:55:24Z Re: Unmatched values problem https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607013#M682301 <HTML><HEAD></HEAD><BODY><P>Use Not exists in load script.</P><P></P><P>-Sundar</P></BODY></HTML> Thu, 06 Mar 2014 05:04:25 GMT https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607013#M682301 sundarakumar 2014-03-06T05:04:25Z Re: Unmatched values problem https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607014#M682302 <HTML><HEAD></HEAD><BODY><P>Hi Vijeta,</P><P></P><P>This can be acheived by Lkup function . Please see the attachment below.</P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Thu, 06 Mar 2014 05:07:11 GMT https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607014#M682302 amit_saini 2014-03-06T05:07:11Z Re: Re: Unmatched values problem https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607015#M682303 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA example of Not eists.</P><P></P><P>-Sundar</P></BODY></HTML> Thu, 06 Mar 2014 05:07:46 GMT https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607015#M682303 sundarakumar 2014-03-06T05:07:46Z Re: Unmatched values problem https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607016#M682304 <HTML><HEAD></HEAD><BODY><P>Thanks,not exists function is working fine</P></BODY></HTML> Thu, 06 Mar 2014 05:41:06 GMT https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607016#M682304 vijetas42 2014-03-06T05:41:06Z Re: Unmatched values problem https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607017#M682305 <HTML><HEAD></HEAD><BODY><P>You are welcome. Please Close the thread once u r done.</P><P>U can close it by marking the correct answer.</P></BODY></HTML> Thu, 06 Mar 2014 05:43:26 GMT https://community.qlik.com/t5/QlikView/Unmatched-values-problem/m-p/607017#M682305 sundarakumar 2014-03-06T05:43:26Z