topic Re: How to identify missing information in QlikView https://community.qlik.com/t5/QlikView/How-to-identify-missing-information/m-p/643353#M235718 <HTML><HEAD></HEAD><BODY><P>Check enclosed file..</P></BODY></HTML> Sat, 07 Jun 2014 07:53:44 GMT MK_QSL 2014-06-07T07:53:44Z How to identify missing information https://community.qlik.com/t5/QlikView/How-to-identify-missing-information/m-p/643351#M235716 <HTML><HEAD></HEAD><BODY><P>Hi averyone!</P><P></P><P>Please look de attached file</P><P></P><P>Can anyone help me?</P></BODY></HTML> Fri, 06 Jun 2014 20:00:56 GMT https://community.qlik.com/t5/QlikView/How-to-identify-missing-information/m-p/643351#M235716 MarcoARaymundo 2014-06-06T20:00:56Z Re: How to identify missing information https://community.qlik.com/t5/QlikView/How-to-identify-missing-information/m-p/643352#M235717 <HTML><HEAD></HEAD><BODY><P>Using selections:</P><P>Select all products - you get customers who bout at least something.&nbsp; Now, in customers, select excluded.</P><P></P><P>Can also do it in expression using set analysis.</P></BODY></HTML> Fri, 06 Jun 2014 20:07:06 GMT https://community.qlik.com/t5/QlikView/How-to-identify-missing-information/m-p/643352#M235717 Anonymous 2014-06-06T20:07:06Z Re: How to identify missing information https://community.qlik.com/t5/QlikView/How-to-identify-missing-information/m-p/643353#M235718 <HTML><HEAD></HEAD><BODY><P>Check enclosed file..</P></BODY></HTML> Sat, 07 Jun 2014 07:53:44 GMT https://community.qlik.com/t5/QlikView/How-to-identify-missing-information/m-p/643353#M235718 MK_QSL 2014-06-07T07:53:44Z Re: How to identify missing information https://community.qlik.com/t5/QlikView/How-to-identify-missing-information/m-p/643354#M235719 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Not sure,</P><P>But try this,</P><P></P><P>Ordered:</P><P>Load</P><P>Customer_key,</P><P>Order_key,</P><P>From Ordered;</P><P></P><P>Customer:</P><P>Load</P><P>Customer_key as customer</P><P>from Customer</P><P>where not exists(Customer_key,customer_key)</P><P></P><P></P><P>Regards,</P></BODY></HTML> Sat, 07 Jun 2014 09:00:05 GMT https://community.qlik.com/t5/QlikView/How-to-identify-missing-information/m-p/643354#M235719 PrashantSangle 2014-06-07T09:00:05Z