Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

Hi!

Find my attachment

Hope this helps!

KR

Elena

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

Hi!

Find my attachment

Hope this helps!

KR

Elena

View solution in original post

Highlighted
Not applicable

Thank you, worked like a charm!