Financial functions can be used in the load script and in chart expressions to calculate payments and interest rates.
For all the
arguments, cash that is paid out is represented by negative numbers. Cash
received is represented by positive numbers.
Listed here are the arguments that are used in the financial functions (excepting the ones beginning with range-).
Information note
For all financial functions it is vital that you are consistent when specifying units for rate
and nper. If monthly
payments are made on a five-year loan at 6% annual interest, use 0.005 (6%/12)
for rate and 60 (5*12) for nper. If annual payments are made on
the same loan, use 6% for rate
and 5 for nper.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
This function returns the future value of an investment based on periodic, constant
payments and a simple annual interest.
This function returns the payment for a loan based on periodic, constant payments
and a constant interest rate. It cannot change over the life of the annuity. A payment is stated as a negative number, for example, -20.
Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com