Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

hico-mah
New Contributor II

Create a list of values to calculate the IRR

Hi everybody,

if got a rather basic Qlik problem I can't get my head around:


I'd like to be able to select some values from which I can calculate a payment rate p, some other selections will result in an investement i and I'm able to chose the duration of payments d. From this I'd like to calculate the IRR.

I'd assume that the RangeIRR function is the method to go, therefore I'd have to create a value list to supply to the RangeIRR function, but I can't figure out how.

As an example:

with i = -2000, p = 800 and d = 5 I must call this function: RangeIRR(-2000, 800,800,800,800,800) (800 is included d times).

Could anybody give me a hint how to calcuate this? Please keep in mind that all three values are variables. Furthermore this can not be done in the data model.

kind regards

Michael

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Create a list of values to calculate the IRR

=RangeIRR($(i), $(=repeat($(p) & ',',$(d))))

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

2 Replies
MVP & Luminary
MVP & Luminary

Re: Create a list of values to calculate the IRR

=RangeIRR($(i), $(=repeat($(p) & ',',$(d))))

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

hico-mah
New Contributor II

Re: Create a list of values to calculate the IRR

thx, it is so easy if you know how to do it