topic Daily interest rate calculation in QlikView https://community.qlik.com/t5/QlikView/Daily-interest-rate-calculation/m-p/86647#M14212 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've attached a sample calculation for daily interst rates in the script. My problem is, that the values/fields that I need to use in the calculation are not created when I start the calculation. I tried around with RangeSum but couldn't find a proper solution. </P><P></P><P>Appreciate any hint!</P><P></P><P>KR, Nigel</P></BODY></HTML> Mon, 03 Sep 2018 10:40:59 GMT nigel987 2018-09-03T10:40:59Z Daily interest rate calculation https://community.qlik.com/t5/QlikView/Daily-interest-rate-calculation/m-p/86647#M14212 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've attached a sample calculation for daily interst rates in the script. My problem is, that the values/fields that I need to use in the calculation are not created when I start the calculation. I tried around with RangeSum but couldn't find a proper solution. </P><P></P><P>Appreciate any hint!</P><P></P><P>KR, Nigel</P></BODY></HTML> Mon, 03 Sep 2018 10:40:59 GMT https://community.qlik.com/t5/QlikView/Daily-interest-rate-calculation/m-p/86647#M14212 nigel987 2018-09-03T10:40:59Z Re: Daily interest rate calculation https://community.qlik.com/t5/QlikView/Daily-interest-rate-calculation/m-p/86648#M14213 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would set the interest rate in a variable:</P><P>let vInterest = 0,09;</P><P></P><P>And then I would work with Peek() function to load data from the previous lines calculated value to the next one for Capital.</P></BODY></HTML> Mon, 03 Sep 2018 12:36:08 GMT https://community.qlik.com/t5/QlikView/Daily-interest-rate-calculation/m-p/86648#M14213 niclaz79 2018-09-03T12:36:08Z