set analysis syntax

Mon, 29 Feb 2016 13:12:30 GMT

I've been having a heck of a time trying to get this to work. What I want is the bad rate, or deliquency rate of loans given to clients. So basically I had this working no problem with =1-SUM({$<DueDatePaymentDelayInDays = {"<=5"}>} PaymentTotal)/SUM({Capital+Fee))

But I don't want this to show up until there are 35 days between today() and OpeningDate so I don't have my line going to 100%:

=1-SUM(IF(today()-OpeningDate>=35, PaymentTotal))/SUM(IF(today()-OpeningDate>=35,Capital+Fee))

Now, this sums everything if 35 or more days have passed since OpeningDate, but what I want is to sum this at a point in time which I reflected in the first formula, where $<DueDatePaymentDelayInDays = {"<=5"}>} , so what I would like would be to incorporate both aspects, don't sum unless it is 35+ days old and only those payments received within the first 5 days of it coming due. But I'm having trouble with the syntax, I have this:

=1-SUM(IF(today()-OpeningDate>=35, SUM{$<DueDatePaymentDelayInDays = {"<=5"}>} PaymentTotal))/SUM(IF(today()-OpeningDate>=35,Capital+Fee))

Any help on this?

Many thanks!

topic set analysis syntax in QlikView

set analysis syntax