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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
veldetta
Contributor III
Contributor III

Find Unmatched Records based on Time Period

So i'm looking to find unmatched records based on a time period.  Let's say i have 2 tables:

Table A  

NameReviewer
John SmithRobert
Don GrantCassie
Louis BrownRobert
Gene DavidCassie
John ThompsonCassie

Table B 

NameReviewerDay Reviewed
John SmithRobertMon
Don GrantCassieTues
Louis BrownRobertMon
Gene DavidCassieThur
John ThompsonCassieFri

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?

1 Reply
vinieme12
Champion III
Champion III

please post some sample data / sample app and also explain a desired output

Preparing examples for Upload - Reduction and Data Scrambling

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.