topic Re: Date Related in QlikView https://community.qlik.com/t5/QlikView/Date-Related/m-p/465040#M173694 <HTML><HEAD></HEAD><BODY><P>Dear Sir,</P><P></P><P>Thanks for the reply.</P><P>In this, If There is IN time and No out time then It should give me that date entry as a missing entry like that person has forgotten to tap-out on that day, so it should find such kind of missing entries.</P></BODY></HTML> Tue, 30 Oct 2012 12:51:15 GMT 2012-10-30T12:51:15Z Date Related https://community.qlik.com/t5/QlikView/Date-Related/m-p/465038#M173692 <HTML><HEAD></HEAD><BODY><P>The attached is the application, in this I want to keep Min and max date only for particular employee on particular date.And if only in time or only out time is there then it should identify the missing entries.</P><P>Please Reply.</P></BODY></HTML> Tue, 30 Oct 2012 09:07:30 GMT https://community.qlik.com/t5/QlikView/Date-Related/m-p/465038#M173692 2012-10-30T09:07:30Z Re: Date Related https://community.qlik.com/t5/QlikView/Date-Related/m-p/465039#M173693 <HTML><HEAD></HEAD><BODY><P>Not Clear what you want exactly</P><P>PFA</P></BODY></HTML> Tue, 30 Oct 2012 12:16:16 GMT https://community.qlik.com/t5/QlikView/Date-Related/m-p/465039#M173693 sivarajs 2012-10-30T12:16:16Z Re: Date Related https://community.qlik.com/t5/QlikView/Date-Related/m-p/465040#M173694 <HTML><HEAD></HEAD><BODY><P>Dear Sir,</P><P></P><P>Thanks for the reply.</P><P>In this, If There is IN time and No out time then It should give me that date entry as a missing entry like that person has forgotten to tap-out on that day, so it should find such kind of missing entries.</P></BODY></HTML> Tue, 30 Oct 2012 12:51:15 GMT https://community.qlik.com/t5/QlikView/Date-Related/m-p/465040#M173694 2012-10-30T12:51:15Z Re: Date Related https://community.qlik.com/t5/QlikView/Date-Related/m-p/465041#M173695 <HTML><HEAD></HEAD><BODY><P>In the file which you have uploaded has all the in and out for employees</P><P>But you can add else condition to the expression to get null values</P><P>Timestamp(min(if([Time Event Type]='IN', SubField([Logical time],' ',1),<SPAN style="color: #ff0000;"><STRONG>'-'</STRONG></SPAN>)),'hh:mm:ss')</P></BODY></HTML> Tue, 30 Oct 2012 13:00:12 GMT https://community.qlik.com/t5/QlikView/Date-Related/m-p/465041#M173695 sivarajs 2012-10-30T13:00:12Z