topic Re: Hi in QlikView https://community.qlik.com/t5/QlikView/Hi/m-p/732386#M262358 <HTML><HEAD></HEAD><BODY><P>hi give me your email id so that i can send you my excel file with requirement</P></BODY></HTML> Thu, 24 Jul 2014 05:41:52 GMT 2014-07-24T05:41:52Z Hi https://community.qlik.com/t5/QlikView/Hi/m-p/732381#M262353 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>I have customer ledger in excel where debit\credit is there, i want to calculate interest penelty for each delay payment made after due date. pls help with formula.</P></BODY></HTML> Wed, 23 Jul 2014 11:36:08 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/732381#M262353 2014-07-23T11:36:08Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/732382#M262354 <HTML><HEAD></HEAD><BODY><P>What data do you have? Is it just values in a Excel sprea sheet?</P></BODY></HTML> Wed, 23 Jul 2014 12:51:36 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/732382#M262354 2014-07-23T12:51:36Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/732383#M262355 <HTML><HEAD></HEAD><BODY><P>(Credit / Debit) - 1 as a percentage.</P></BODY></HTML> Wed, 23 Jul 2014 13:30:46 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/732383#M262355 2014-07-23T13:30:46Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/732384#M262356 <HTML><HEAD></HEAD><BODY><P>You mean like:</P><P>LOAD</P><P>TransID,</P><P>Amount,</P><P>DueDate,</P><P>Interval(Today()-DueDate, 'D') as DaysOverDue</P><P>...</P><P></P><P>expression:&nbsp; =Amount * DaysOverDue * vDailyRate</P><P></P><P>?</P><P>M.</P></BODY></HTML> Wed, 23 Jul 2014 13:40:56 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/732384#M262356 martynlloyd 2014-07-23T13:40:56Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/732385#M262357 <HTML><HEAD></HEAD><BODY><P>Expression1 = (Amount * DaysOverDue * vDailyRate) + Amount to get total outstanding amount including interest</P><P>Expression2 = (Expression1 / Amount) - 1 to get the total interest charged.</P><P></P><P>Regards,<BR />Marius</P></BODY></HTML> Wed, 23 Jul 2014 13:50:39 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/732385#M262357 2014-07-23T13:50:39Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/732386#M262358 <HTML><HEAD></HEAD><BODY><P>hi give me your email id so that i can send you my excel file with requirement</P></BODY></HTML> Thu, 24 Jul 2014 05:41:52 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/732386#M262358 2014-07-24T05:41:52Z