So i'm looking to find unmatched records based on a time period. Let's say i have 2 tables:
Table A
| Name | Reviewer |
| John Smith | Robert |
| Don Grant | Cassie |
| Louis Brown | Robert |
| Gene David | Cassie |
| John Thompson | Cassie |
Table B
| Name | Reviewer | Day Reviewed |
| John Smith | Robert | Mon |
| Don Grant | Cassie | Tues |
| Louis Brown | Robert | Mon |
| Gene David | Cassie | Thur |
| John Thompson | Cassie | Fri |
and let's say i have a list box with days of the week. Let's say I select 'Mon', i want qlikview to show me who hasn't be reviewed in that day. This is just a simplified version of what i'm trying to do, the real scenario is by month within the quarter.
What's the best way to handle this?
