topic Comptage avec conditions multiples in QlikView https://community.qlik.com/t5/QlikView/Comptage-avec-conditions-multiples/m-p/483167#M180567 <HTML><HEAD></HEAD><BODY><P>Bonjour</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Je cherche à calculer le nombre d'adhérents à un instant T, en l'occurrence au jour même.</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">J'utilise l'expression suivante qui ne me ramène rien. pourtant expression ok.</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Je pense que c'est une question d'union ou d'intersection…</SPAN></P><P></P><P><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;">count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({$&lt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">LIAISON_POLICE_DTAFFIL</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;">"&lt;=Today()"</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;">LIAISON_POLICE_DTRADIAT</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;">"&gt;=Today()"</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;">ADHERENT_DTSORTIE</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;">"&gt;=Today()"</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">}&gt;}</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">ADHERENT_NOUNIQUE</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">) </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Je cherche à mettre les conditions </SPAN></P><P><SPAN style="color: #800000; font-size: 12px; font-family: 'Courier New';">LIAISON_POLICE_DTAFFIL&lt;=aujourd'hui</SPAN></P><P><SPAN style="color: #800000; font-size: 12px; font-family: 'Courier New';">et</SPAN></P><P><SPAN style="color: #800000; font-size: 12px; font-family: 'Courier New';">&nbsp;&nbsp;&nbsp;&nbsp; |<SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">LIAISON_POLICE_DTRADIAT&gt;=<SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">aujourd'hui</SPAN></SPAN></SPAN></P><P><SPAN style="color: #800000; font-size: 12px; font-family: 'Courier New';">&nbsp;&nbsp;&nbsp;&nbsp; ou</SPAN></P><P><SPAN style="color: #800000; font-size: 12px; font-family: 'Courier New';"><SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">&nbsp;&nbsp;&nbsp;&nbsp; |<SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">ADHERENT_DTSORTIE&gt;=<SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">aujourd'hui</SPAN></SPAN></SPAN><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Merci<BR /></SPAN></P></BODY></HTML> Fri, 13 Dec 2013 16:15:04 GMT 2013-12-13T16:15:04Z Comptage avec conditions multiples https://community.qlik.com/t5/QlikView/Comptage-avec-conditions-multiples/m-p/483167#M180567 <HTML><HEAD></HEAD><BODY><P>Bonjour</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Je cherche à calculer le nombre d'adhérents à un instant T, en l'occurrence au jour même.</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">J'utilise l'expression suivante qui ne me ramène rien. pourtant expression ok.</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif';">Je pense que c'est une question d'union ou d'intersection…</SPAN></P><P></P><P><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;">count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">({$&lt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">LIAISON_POLICE_DTAFFIL</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;">"&lt;=Today()"</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;">LIAISON_POLICE_DTRADIAT</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;">"&gt;=Today()"</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;">ADHERENT_DTSORTIE</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;">"&gt;=Today()"</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">}&gt;}</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">ADHERENT_NOUNIQUE</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">) </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Je cherche à mettre les conditions </SPAN></P><P><SPAN style="color: #800000; font-size: 12px; font-family: 'Courier New';">LIAISON_POLICE_DTAFFIL&lt;=aujourd'hui</SPAN></P><P><SPAN style="color: #800000; font-size: 12px; font-family: 'Courier New';">et</SPAN></P><P><SPAN style="color: #800000; font-size: 12px; font-family: 'Courier New';">&nbsp;&nbsp;&nbsp;&nbsp; |<SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">LIAISON_POLICE_DTRADIAT&gt;=<SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">aujourd'hui</SPAN></SPAN></SPAN></P><P><SPAN style="color: #800000; font-size: 12px; font-family: 'Courier New';">&nbsp;&nbsp;&nbsp;&nbsp; ou</SPAN></P><P><SPAN style="color: #800000; font-size: 12px; font-family: 'Courier New';"><SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">&nbsp;&nbsp;&nbsp;&nbsp; |<SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">ADHERENT_DTSORTIE&gt;=<SPAN style="color: #800000; font-family: 'Courier New'; font-size: 12px;">aujourd'hui</SPAN></SPAN></SPAN><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Merci<BR /></SPAN></P></BODY></HTML> Fri, 13 Dec 2013 16:15:04 GMT https://community.qlik.com/t5/QlikView/Comptage-avec-conditions-multiples/m-p/483167#M180567 2013-12-13T16:15:04Z Re: Comptage avec conditions multiples https://community.qlik.com/t5/QlikView/Comptage-avec-conditions-multiples/m-p/483168#M180568 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">=</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">count</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">({$&lt;</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">LIAISON_POLICE_DTAFFIL</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">"&lt;=Today()"</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">},</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">LIAISON_POLICE_DTRADIAT</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">"&gt;=Today()"</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">}&gt;+&lt;<SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">LIAISON_POLICE_DTAFFIL</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">"&lt;=Today()"</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">}</SPAN>,</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">ADHERENT_DTSORTIE</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">"&gt;=Today()"</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">}&gt;}</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">ADHERENT_NOUNIQUE</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">)</SPAN></P></BODY></HTML> Fri, 13 Dec 2013 17:01:55 GMT https://community.qlik.com/t5/QlikView/Comptage-avec-conditions-multiples/m-p/483168#M180568 Gysbert_Wassenaar 2013-12-13T17:01:55Z