Thanks for this video! Have not come across any online academy/course that responds to query with a video in less than 24 hours. I would highly recommend Analytics Hub io to anyone seeking to become a Qlik developer. This is the best online / instructor-led course available in the Qlikview / Qlik Sense world.
Can help with this expression:if(%Key_LoanNumber=Peek(%Key_LoanNumber),Peek(Balance_eop)-(pmt((AnnualInterestRate_EOP/12),Duration_EOP,-Peek(balance_eop))-(Peek(balance_eop)*(AnnualInterestRate_EOP/12))),Balance_BOP) as balance_eop it is not working when loan are same