topic Re: Regarding QVD optimization in QlikView https://community.qlik.com/t5/QlikView/Regarding-QVD-optimization/m-p/666986#M1062437 <HTML><HEAD></HEAD><BODY><P>You can use a WHERE NOT EXISTS (KEYFIELD) to prevent duplicates being loaded.</P></BODY></HTML> Tue, 23 Sep 2014 07:03:01 GMT Colin-Albert 2014-09-23T07:03:01Z Regarding QVD optimization https://community.qlik.com/t5/QlikView/Regarding-QVD-optimization/m-p/666984#M1062435 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a requirement regarding qlikview optimization in qvds. Assume there is excel file with 1lakh records out of which 25000 are duplicates, now consider I am creating a qvd file for this excel.</P><P></P><P>My requirement is before creating the qvd can we give notify the developer of having redundant data in the excel file.I heard that there is a mechanism know as <STRONG>notify ,</STRONG>but I am unaware of it. Can anybody let me know.</P><P></P><P>Thank You.</P></BODY></HTML> Tue, 23 Sep 2014 06:05:38 GMT https://community.qlik.com/t5/QlikView/Regarding-QVD-optimization/m-p/666984#M1062435 2014-09-23T06:05:38Z Re: Regarding QVD optimization https://community.qlik.com/t5/QlikView/Regarding-QVD-optimization/m-p/666985#M1062436 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>you can give WHERE EXISTS while creating qvd it will allow only exists value so you can avoid the nulls</P><P>EX:</P><P>WHERE EXISTS(field name)</P></BODY></HTML> Tue, 23 Sep 2014 06:18:18 GMT https://community.qlik.com/t5/QlikView/Regarding-QVD-optimization/m-p/666985#M1062436 arulsettu 2014-09-23T06:18:18Z Re: Regarding QVD optimization https://community.qlik.com/t5/QlikView/Regarding-QVD-optimization/m-p/666986#M1062437 <HTML><HEAD></HEAD><BODY><P>You can use a WHERE NOT EXISTS (KEYFIELD) to prevent duplicates being loaded.</P></BODY></HTML> Tue, 23 Sep 2014 07:03:01 GMT https://community.qlik.com/t5/QlikView/Regarding-QVD-optimization/m-p/666986#M1062437 Colin-Albert 2014-09-23T07:03:01Z