Can someone help me with this script?

Tue, 23 Aug 2011 10:57:25 GMT

Hello Experts,

I have a below script from which I want to calculate DefaultRate. The formula to do it is, I need to check if any LoanKey made 3 consecutive payments and then a default I need to calculate it. How can I acheive it with below tables? I have LoanKey and then Reporting Date Key and Amount as seen below. I need to look for customers who havent paid anytime after 3 consecutive payment months.

vLastFctPayment:

LOAD

PaymentID,

PortfolioKey,

YearMonth,

PaymentSequence,

LoanKey,

AddressKey,

PersonKey,

PaymentPlanKey,

TransactionTypeKey,

TransactionDateKey as ReportingDateKey,

TransactionDateKey as PaymentTransactionDateKey,

PostedDateKey,

ClearedDateKey,

Amount ;

SQL SELECT *

FROM "Table

where Portfoliokey=$(vPortfoliokey);

Thanks a ton in advance and any suggestion is welcome.

Mady

topic Can someone help me with this script? in QlikView

Can someone help me with this script?