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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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