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: 
Not applicable

Determine Outflow by comparing counts on different days

I have a table that has 2 fields:  Account Number and Date Completed.  I want to check if an Account Number on a given date exists on the following date.  If it exists, I can flag it as NOT complete.  If it does not exist, I can flag it as complete.  Can anyone help me with the code that I can put in the load script that would allow me to do this?  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.

Account NumberDate Completed
123451/5/15
123401/5/15
123801/5/15
123451/8/15
123801/8/15
123951/8/15

Thanks!

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi!

Find my attachment

Hope this helps!

KR

Elena

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi!

Find my attachment

Hope this helps!

KR

Elena

Not applicable
Author

Thank you, worked like a charm!