topic Re: Question sur &quot;where + input&quot; in Francophones https://community.qlik.com/t5/Francophones/Question-sur-quot-where-input-quot/m-p/1399526#M12581 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>Essaye en mettant entre quote la variable</P><P></P><P>where MVT_DATE='$(DateMvt)'</P></BODY></HTML> Tue, 12 Sep 2017 15:06:33 GMT Anonymous 2017-09-12T15:06:33Z Question sur "where + input" https://community.qlik.com/t5/Francophones/Question-sur-quot-where-input-quot/m-p/1399524#M12579 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P>je voudrais utiliser la valeur de l' "input" DateMvT dans la condition "where" de mon script :</P><P></P><P></P><P style="margin-bottom: .0001pt;"><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">let</STRONG> <STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">AAAAMMJJ</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> = </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">INPUT</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">('AnnéeMoisJour (AAAAMMJJ) ?','Date de consultation');<BR /></SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">let</STRONG> <STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">DateMvt</EM></STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> = </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Date</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Date#</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">AAAAMMJJ</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,'YYYYMMDD'),'DD/MM/YYYY'); </SPAN></P><P></P><P>LOAD ...</P><P>... </P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">where</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">MVT_DATE</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">=</SPAN><STRONG><EM style="color: gray; font-size: 9.0pt; font-family: 'Courier New';">$(DateMvt) ; </EM></STRONG></P><P></P><P>Comment dois-je écrire ma condition " where" ?</P><P></P><P>Merci beaucoup !</P></BODY></HTML> Tue, 12 Sep 2017 14:18:23 GMT https://community.qlik.com/t5/Francophones/Question-sur-quot-where-input-quot/m-p/1399524#M12579 2017-09-12T14:18:23Z Re: Question sur "where + input" https://community.qlik.com/t5/Francophones/Question-sur-quot-where-input-quot/m-p/1399525#M12580 <HTML><HEAD></HEAD><BODY><P>Essai :</P><P></P><P>where match(<SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">MVT_DATE</SPAN>,$(<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 9pt; font-family: 'Courier New'; color: gray;">DateMvt</EM></STRONG>));</P><P></P><P>Kevin</P></BODY></HTML> Tue, 12 Sep 2017 15:01:42 GMT https://community.qlik.com/t5/Francophones/Question-sur-quot-where-input-quot/m-p/1399525#M12580 kevinchevrier 2017-09-12T15:01:42Z Re: Question sur "where + input" https://community.qlik.com/t5/Francophones/Question-sur-quot-where-input-quot/m-p/1399526#M12581 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>Essaye en mettant entre quote la variable</P><P></P><P>where MVT_DATE='$(DateMvt)'</P></BODY></HTML> Tue, 12 Sep 2017 15:06:33 GMT https://community.qlik.com/t5/Francophones/Question-sur-quot-where-input-quot/m-p/1399526#M12581 Anonymous 2017-09-12T15:06:33Z Re: Question sur "where + input" https://community.qlik.com/t5/Francophones/Question-sur-quot-where-input-quot/m-p/1399527#M12582 <HTML><HEAD></HEAD><BODY><P>Cela fonctionne, merci beaucoup Anne !</P></BODY></HTML> Tue, 12 Sep 2017 15:52:21 GMT https://community.qlik.com/t5/Francophones/Question-sur-quot-where-input-quot/m-p/1399527#M12582 2017-09-12T15:52:21Z