topic Re: Clause Where in QlikView https://community.qlik.com/t5/QlikView/Clause-Where/m-p/885407#M308735 <HTML><HEAD></HEAD><BODY><P>My QVD is not empty. But you are right!</P><P>I don't understand why you need this quote here. Could you explain me?</P></BODY></HTML> Tue, 19 May 2015 11:43:59 GMT 2015-05-19T11:43:59Z Clause Where https://community.qlik.com/t5/QlikView/Clause-Where/m-p/885405#M308733 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P>Je travaille actuellement sur Q11 et test actuellement le chargement incrémental.</P><P>Je ne comprend pas trop pourquoi la clause WHERE ne fonctionne pas ici.</P><P>Les données de mon QVD. </P><P><IMG alt="test2.png" class="jive-image image-2" height="77" src="https://community.qlik.com/legacyfs/online/86880_test2.png" style="height: 76.791277258567px; width: 170px;" width="170" /></P><P><SPAN style="font-size: 13.3333330154419px;">Je veux récupérer les chacune des colonnes modifiés à l'aide du champ date_modification</SPAN></P><P><IMG alt="test.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86879_test.png" style="height: 233px; width: 620px;" /></P><P>Catastrophe lors du chargement des données :</P><P></P><P><IMG alt="3.png" class="jive-image image-3" height="106" src="https://community.qlik.com/legacyfs/online/86881_3.png" style="height: 105.879310344828px; width: 345px;" width="345" /></P><P></P><P>Je ne vois pas ce qui pose problème. Merci par avance.</P><P>Cdt,</P><P>RR</P></BODY></HTML> Tue, 19 May 2015 09:16:25 GMT https://community.qlik.com/t5/QlikView/Clause-Where/m-p/885405#M308733 2015-05-19T09:16:25Z Re: Clause Where https://community.qlik.com/t5/QlikView/Clause-Where/m-p/885406#M308734 <HTML><HEAD></HEAD><BODY><P>Since QVD file is empty, null is assigned to vLastUpdate. <SPAN style="font-size: 13.3333330154419px;">Do you have any data in QVD?</SPAN></P><P></P><P>In Where clause use quotes around variable <SPAN style="font-size: 13.3333330154419px;">vLastUpdate</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Where DATE_NOTIFICATION &gt; '$(vLastUpdate)'</SPAN></P></BODY></HTML> Tue, 19 May 2015 09:42:54 GMT https://community.qlik.com/t5/QlikView/Clause-Where/m-p/885406#M308734 anbu1984 2015-05-19T09:42:54Z Re: Clause Where https://community.qlik.com/t5/QlikView/Clause-Where/m-p/885407#M308735 <HTML><HEAD></HEAD><BODY><P>My QVD is not empty. But you are right!</P><P>I don't understand why you need this quote here. Could you explain me?</P></BODY></HTML> Tue, 19 May 2015 11:43:59 GMT https://community.qlik.com/t5/QlikView/Clause-Where/m-p/885407#M308735 2015-05-19T11:43:59Z Re: Clause Where https://community.qlik.com/t5/QlikView/Clause-Where/m-p/885408#M308736 <HTML><HEAD></HEAD><BODY><P>Quotes are required for Dates and String literals. It is not required for integer</P></BODY></HTML> Tue, 19 May 2015 13:10:12 GMT https://community.qlik.com/t5/QlikView/Clause-Where/m-p/885408#M308736 anbu1984 2015-05-19T13:10:12Z