Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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!

Tags (2)
1 Solution

Accepted Solutions
elena888
Valued Contributor

Re: Determine Outflow by comparing counts on different days

Hi!

Find my attachment

Hope this helps!

KR

Elena

2 Replies
elena888
Valued Contributor

Re: Determine Outflow by comparing counts on different days

Hi!

Find my attachment

Hope this helps!

KR

Elena

Not applicable

Re: Determine Outflow by comparing counts on different days

Thank you, worked like a charm!

Community Browser