topic Re: Determine Outflow by comparing counts on different days in QlikView https://community.qlik.com/t5/QlikView/Determine-Outflow-by-comparing-counts-on-different-days/m-p/743208#M664224 <HTML><HEAD></HEAD><BODY><P>Thank you, worked like a charm!</P></BODY></HTML> Tue, 06 Jan 2015 18:23:14 GMT 2015-01-06T18:23:14Z Determine Outflow by comparing counts on different days https://community.qlik.com/t5/QlikView/Determine-Outflow-by-comparing-counts-on-different-days/m-p/743206#M664222 <HTML><HEAD></HEAD><BODY><P>I have a table that has 2 fields:&nbsp; Account Number and Date Completed.&nbsp; I want to check if an Account Number on a given date exists on the following date.&nbsp; If it exists, I can flag it as NOT complete.&nbsp; If it does not exist, I can flag it as complete.&nbsp; Can anyone help me with the code that I can put in the load script that would allow me to do this?&nbsp; In the example below, the account 12340 on 1/5/15 would be flagged as 'complete' because it doesn't exist in the next existing date, which is 1/8/15.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Account Number</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Date Completed</TH></TR><TR><TD style="padding: 2px;">12345</TD><TD style="padding: 2px;">1/5/15</TD></TR><TR><TD style="padding: 2px;">12340</TD><TD style="padding: 2px;">1/5/15</TD></TR><TR><TD style="padding: 2px;">12380</TD><TD style="padding: 2px;">1/5/15</TD></TR><TR><TD style="padding: 2px;">12345</TD><TD style="padding: 2px;">1/8/15</TD></TR><TR><TD style="padding: 2px;">12380</TD><TD style="padding: 2px;">1/8/15</TD></TR><TR><TD style="padding: 2px;">12395</TD><TD style="padding: 2px;">1/8/15</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks!</P></BODY></HTML> Tue, 06 Jan 2015 16:55:16 GMT https://community.qlik.com/t5/QlikView/Determine-Outflow-by-comparing-counts-on-different-days/m-p/743206#M664222 2015-01-06T16:55:16Z Re: Determine Outflow by comparing counts on different days https://community.qlik.com/t5/QlikView/Determine-Outflow-by-comparing-counts-on-different-days/m-p/743207#M664223 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>Find my attachment</P><P>Hope this helps!</P><P></P><P>KR</P><P>Elena</P></BODY></HTML> Tue, 06 Jan 2015 18:00:12 GMT https://community.qlik.com/t5/QlikView/Determine-Outflow-by-comparing-counts-on-different-days/m-p/743207#M664223 Anonymous 2015-01-06T18:00:12Z Re: Determine Outflow by comparing counts on different days https://community.qlik.com/t5/QlikView/Determine-Outflow-by-comparing-counts-on-different-days/m-p/743208#M664224 <HTML><HEAD></HEAD><BODY><P>Thank you, worked like a charm!</P></BODY></HTML> Tue, 06 Jan 2015 18:23:14 GMT https://community.qlik.com/t5/QlikView/Determine-Outflow-by-comparing-counts-on-different-days/m-p/743208#M664224 2015-01-06T18:23:14Z