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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.