Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Daily interest rate calculation


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.

Appreciate any hint!

KR, Nigel

1 Reply
Partner - Creator III
Partner - Creator III


I would set the interest rate in a variable:

let vInterest = 0,09;

And then I would work with Peek() function to load data from the previous lines calculated value to the next one for Capital.