Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Count({<IN1={">$(=SHIFTSTARTTIME)"},time((IN1-SHIFTSTARTTIME),'hh:mm:ss')={"<$(=00:10:00)"}>}PAYCODE)
IN1 - Field
Shiftstarttime- field
paycode- primary key field
paycode- Employee id
IN1- in this Employee entry time is given in format '09-Apr-2014 09:35:00'
Shiftstarttime- in this Employee Shift Start time is given in format '09-Apr-2014 08:30:00'
by above expression i want to count no .of employee who are late but are late between 0- 10 min... but error is coming please help
This appears to be a duplicate of need help with this expression .
navneet kaushal please delete thread or mark it as resolved.
actually i forgot to attatched the test qlikview with this one thats y ...i will delete this one