Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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.