topic Expression pointage in QlikView https://community.qlik.com/t5/QlikView/Expression-pointage/m-p/724237#M259841 <HTML><HEAD></HEAD><BODY><P>Comment corriger cette expression ci dessous pour quel me retourne dEvent_Date = '1' si le pointage avant 08:30 si non elle me retourne '0'</P><P></P><P><STRONG style="font-size: 12pt;">if(num(Hour(dEvent_Date))&lt;='08' and num(Minute(dEvent_Date))&lt;='30','1','0') as T830,</STRONG></P></BODY></HTML> Tue, 30 Sep 2014 08:17:03 GMT 2014-09-30T08:17:03Z Expression pointage https://community.qlik.com/t5/QlikView/Expression-pointage/m-p/724237#M259841 <HTML><HEAD></HEAD><BODY><P>Comment corriger cette expression ci dessous pour quel me retourne dEvent_Date = '1' si le pointage avant 08:30 si non elle me retourne '0'</P><P></P><P><STRONG style="font-size: 12pt;">if(num(Hour(dEvent_Date))&lt;='08' and num(Minute(dEvent_Date))&lt;='30','1','0') as T830,</STRONG></P></BODY></HTML> Tue, 30 Sep 2014 08:17:03 GMT https://community.qlik.com/t5/QlikView/Expression-pointage/m-p/724237#M259841 2014-09-30T08:17:03Z Re: Expression pointage https://community.qlik.com/t5/QlikView/Expression-pointage/m-p/724238#M259842 <HTML><HEAD></HEAD><BODY><P>Quel est le format de dEvent_Date ?</P></BODY></HTML> Tue, 30 Sep 2014 08:27:51 GMT https://community.qlik.com/t5/QlikView/Expression-pointage/m-p/724238#M259842 antoniotiman 2014-09-30T08:27:51Z Re: Expression pointage https://community.qlik.com/t5/QlikView/Expression-pointage/m-p/724239#M259843 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="144"><TBODY><TR><TD align="right" class="xl63" height="20" style="font-size: 11pt; color: black; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none; border-top-color: #9bc2e6; border-bottom-width: 0.5pt; border-bottom-color: #9bc2e6;" width="144">11/06/2014 09:03</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 30 Sep 2014 08:36:45 GMT https://community.qlik.com/t5/QlikView/Expression-pointage/m-p/724239#M259843 2014-09-30T08:36:45Z Re: Expression pointage https://community.qlik.com/t5/QlikView/Expression-pointage/m-p/724240#M259844 <HTML><HEAD></HEAD><BODY><P>if(num(Hour(dEvent_Date))&lt;='08' and num(Minute(dEvent_Date))&lt;='30' or ((num(Hour(dEvent_Date))&lt;'08' and num(Minute(dEvent_Date))&gt;'30')) ,'1','0') as T830,</P></BODY></HTML> Tue, 30 Sep 2014 08:53:33 GMT https://community.qlik.com/t5/QlikView/Expression-pointage/m-p/724240#M259844 2014-09-30T08:53:33Z