Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mikegauntlett
Contributor III
Contributor III

SUM If per criteria

Hi Guys, 

so I have projects and projects have multiple invoices. 

Invoices can either be marked as Paid or Past due. 

I need to get a 'YES' or a 'NO' as to whether the project has a past due invoice. 

How can I write a script in the data load editor to accomplish this? 

so far I have 

IF(Invoice_Plan_Payment_Status = 'Past Due','1','0') as Pay_score,

then 

SUM({<Pay_score={1}, But now have no idea how to run it per project

Labels (2)
1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

Are you saying you want to be able to identify any project with 1 (or more) overdue invoices?

What are you adding up in the script? Values from all the invoices from the project, or just the overdue ones? Do you want to lose the detail when aggregating in the script, or do you want to keep the detail as well? Have you got massive amounts of data, so you have to aggregate?

If you put some sample lines of data and what you would want shown I might be able to share some other ideas.

Cheers,

Chris.