topic Help - Expression in QlikView

Help - Expression

Anonymous — Tue, 16 Aug 2016 20:17:39 GMT

Hi All,

Im working on an xirr expression and some how number are showing blank when I have a value of 10 or 1 for Type="EMV". I tried on excel and it works fine. However when I change the value to 20 for Type="EMV, XIRR does show with -99.767%

Attached sample QVW.

Any input greatly appreciated!!

Thanks,

Frank

Re: Help - Expression

sunny_talwar — Tue, 16 Aug 2016 20:24:51 GMT

I guess it is crossing -100% once the number goes below 15 and QlikView is unable to show any value.

Re: Help - Expression

timsworldroamer — Tue, 16 Aug 2016 20:42:29 GMT

Not exactly familiar with the XIRR function but upon some experiments it looks like you could be breaking the limit with the Amount for the first row (EMV) = 10. At 14.445 the XIRR = -99.805%.

Hope this helps.

Re: Help - Expression

Anonymous — Wed, 17 Aug 2016 02:11:41 GMT

Sunny and Tim,

Thanks for your responses.

What I try to accomplish here is when I use this xirr function in Excel I can compute an IRR % when "EMV" = 0, so I thought it might be the "0" cause not showing any value within Qlikview. I guess, there are unknown reasons why it's not showing on Qlikview.