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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

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