SUM If per criteria

mikegauntlett — Sat, 16 Nov 2024 02:53:05 GMT

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

Re: SUM If per criteria

chrismarlow — Wed, 31 Jul 2019 18:55:17 GMT

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.

topic SUM If per criteria in QlikView

SUM If per criteria

Re: SUM If per criteria