# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

## How to calculate IRR

Hello everyone

I am trying to figure out how to calculate the IRR (internal rate of return) using the data from Qlikview.

Here are the numbers

Investment - 1.875 mln

cash flows 1 - 200k

cash flows 2 - 233k

cash flows 3 - 233k

cash flows 4  -233k

cash flows 5  -233k

When I calculate it in excel, the number should be -14.55%.

I don't know how to create the formula in qlikview.

I think there is a rangesum formula involved at some point, but I am unsure.

Any help would be very much appreciated.

Thanks
Tom

Tags (2)
1 Solution

Accepted Solutions
Luminary

## Re: Re: How to calculate IRR

Hi Thomas, it should work just like that.

IRR

-1875000

233000

233000

233000

233000

200000

];

and then in a text box object put this formula:

=IRR(IRR)

7 Replies
Partner

## Re: How to calculate IRR

Hi,

could you explain which formula do you use in excel ?

Not applicable

## Re: How to calculate IRR

sure

It's just =IRR(investment data and cash flows)

 -1,875,000.00 200,000.00 233,000.00 233,000.00 233,000.00 233,000.00

total is -14.59%

Employee

## Re: How to calculate IRR

QlikView has IRR function, just use it

=IRR(yourfield)

Be careful, your investments and cash flows must have opposite signs

Not applicable

## Re: How to calculate IRR

Thanks

but how to I translate the above information into what qlikview will calculate which is

IRR([Total[<fld{,fld}>]]value)

Thanks my problem

Thanks

Tom

Luminary

## Re: Re: How to calculate IRR

Hi Thomas, it should work just like that.

IRR

-1875000

233000

233000

233000

233000

200000

];

and then in a text box object put this formula:

=IRR(IRR)

Not applicable

## Re: Re: How to calculate IRR

Thank you so much for this.

Tom

New Contributor II

## Re: How to calculate IRR

Hello,

I just Want to know How IRR Function Calculation Works.