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

[akile002]

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

[m_woolf]

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.

[YoussefBelloum]

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

[akile002]

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