topic Re: Find Unmatched Records based on Time Period in QlikView https://community.qlik.com/t5/QlikView/Find-Unmatched-Records-based-on-Time-Period/m-p/1337544#M412437 <HTML><HEAD></HEAD><BODY><P>please post some sample data / sample app and also explain a desired output</P><P></P><P><A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Wed, 19 Apr 2017 07:20:42 GMT vinieme12 2017-04-19T07:20:42Z Find Unmatched Records based on Time Period https://community.qlik.com/t5/QlikView/Find-Unmatched-Records-based-on-Time-Period/m-p/1337543#M412436 <HTML><HEAD></HEAD><BODY><P>So i'm looking to find unmatched records based on a time period.&nbsp; Let's say i have 2 tables:</P><P></P><P>Table A&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="169"><TBODY><TR><TD height="20" width="105">Name</TD><TD width="64">Reviewer</TD></TR><TR><TD height="20">John Smith</TD><TD>Robert</TD></TR><TR><TD height="20">Don Grant</TD><TD>Cassie</TD></TR><TR><TD height="20">Louis Brown</TD><TD>Robert</TD></TR><TR><TD height="20">Gene David</TD><TD>Cassie</TD></TR><TR><TD height="20">John Thompson</TD><TD>Cassie</TD></TR></TBODY></TABLE><P></P><P></P><P>Table B&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD height="20" width="64">Name</TD><TD width="64">Reviewer</TD><TD width="64">Day Reviewed</TD></TR><TR><TD height="20">John Smith</TD><TD>Robert</TD><TD>Mon</TD></TR><TR><TD height="20">Don Grant</TD><TD>Cassie</TD><TD>Tues</TD></TR><TR><TD height="20">Louis Brown</TD><TD>Robert</TD><TD>Mon</TD></TR><TR><TD height="20">Gene David</TD><TD>Cassie</TD><TD>Thur</TD></TR><TR><TD height="20">John Thompson</TD><TD>Cassie</TD><TD>Fri</TD></TR></TBODY></TABLE><P></P><P>and let's say i have a list box with days of the week.&nbsp; Let's say I select 'Mon', i want qlikview to show me who hasn't be reviewed in that day.&nbsp; This is just a simplified version of what i'm trying to do, the real scenario is by month within the quarter. </P><P></P><P>What's the best way to handle this?</P></BODY></HTML> Tue, 18 Apr 2017 19:37:48 GMT https://community.qlik.com/t5/QlikView/Find-Unmatched-Records-based-on-Time-Period/m-p/1337543#M412436 veldetta 2017-04-18T19:37:48Z Re: Find Unmatched Records based on Time Period https://community.qlik.com/t5/QlikView/Find-Unmatched-Records-based-on-Time-Period/m-p/1337544#M412437 <HTML><HEAD></HEAD><BODY><P>please post some sample data / sample app and also explain a desired output</P><P></P><P><A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Wed, 19 Apr 2017 07:20:42 GMT https://community.qlik.com/t5/QlikView/Find-Unmatched-Records-based-on-Time-Period/m-p/1337544#M412437 vinieme12 2017-04-19T07:20:42Z