Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I need help with this expression

=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

Labels (1)
2 Replies
ToniKautto
Employee
Employee

This appears to be a duplicate of need help with this expression .

navneet kaushal please delete thread or mark it as resolved.

Not applicable
Author

actually i forgot to attatched the test qlikview with this one thats y ...i will delete this one