topic Re: Select Employees that did not receive a paycheck and show the last date they received a check in QlikView

Select Employees that did not receive a paycheck and show the last date they received a check

akile002 — Fri, 06 Oct 2017 15:08:58 GMT

Hey everyone,

I want to be able to pull employees that did not receive a paycheck for a date I select. I am pulling all active employees from my employee table and combining it with the paycheck table, but I am unsure of how to only pull those that did not receive a paycheck on the check date I select in my QlikView. Any help would be greatly appreciated.

Employee Table:

EmpNo,

EmpName,

Check Table:

CKEmpNo,

CKDate,

GrossPay

Re: Select Employees that did not receive a paycheck and show the last date they received a check

m_woolf — Fri, 06 Oct 2017 15:16:04 GMT

If you can select the employees who got paychecks on the selected date, then you can do Select Excluded to get the other employees. max(CKDate) would show the last date when they got a check.

Re: Select Employees that did not receive a paycheck and show the last date they received a check

YoussefBelloum — Fri, 06 Oct 2017 15:25:40 GMT

Do you have null values or 0 on the lines where employees did not receive a paycheck ?

Re: Select Employees that did not receive a paycheck and show the last date they received a check

akile002 — Fri, 06 Oct 2017 15:32:46 GMT

Sadly, no and I'm not sure why. It's just ignoring them completely when I select a check date.