topic Need help with an expression. in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-an-expression/m-p/297150#M110227 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I have <STRONG>YearMonth and LoanKey </STRONG>as a Dimensions.I want to calculate default loans, and the formula is to check if a customer had made 3 consecutive payments in the last 3 months and if missed the 4th payment, then its a default.&nbsp; </P><P></P><P>In detail: If a cusotmer paid in the YearMonths 2011-03, 2011-04, 2011-05, 2011-06 (Works Normally)</P><P>Customer paid in the YearMonths 2011-03, 2011-04,2011-05, (This is a default as he dint pay in 2011-06) This check has to be done across all the months and then get the status in that YearMonth.</P><P></P><P>Thanks in Advance</P><P></P><P>Mady</P></BODY></HTML> Wed, 24 Aug 2011 14:18:25 GMT 2011-08-24T14:18:25Z Need help with an expression. https://community.qlik.com/t5/QlikView/Need-help-with-an-expression/m-p/297150#M110227 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I have <STRONG>YearMonth and LoanKey </STRONG>as a Dimensions.I want to calculate default loans, and the formula is to check if a customer had made 3 consecutive payments in the last 3 months and if missed the 4th payment, then its a default.&nbsp; </P><P></P><P>In detail: If a cusotmer paid in the YearMonths 2011-03, 2011-04, 2011-05, 2011-06 (Works Normally)</P><P>Customer paid in the YearMonths 2011-03, 2011-04,2011-05, (This is a default as he dint pay in 2011-06) This check has to be done across all the months and then get the status in that YearMonth.</P><P></P><P>Thanks in Advance</P><P></P><P>Mady</P></BODY></HTML> Wed, 24 Aug 2011 14:18:25 GMT https://community.qlik.com/t5/QlikView/Need-help-with-an-expression/m-p/297150#M110227 2011-08-24T14:18:25Z