topic Re: Expression Help in QlikView

Expression Help

Anonymous — Mon, 15 Feb 2016 16:12:33 GMT

Hi All,

I working on an xirr calculation and wanted to excluded company "ABC". I added '-' after Company to exclude 'ABC' but not getting any results.

=XIRR(aggr({<Company-='ABC.'>},Company,Amount),[Date])

Any feedback greatly appreciated!

Thanks,

Frank

Re: Expression Help

satishkurra — Mon, 15 Feb 2016 16:14:24 GMT

Try this

=XIRR(aggr(Sum({<Company-='ABC.'>},Amount),Company),[Date])

Re: Expression Help

sunny_talwar — Mon, 15 Feb 2016 16:37:13 GMT

Set Analysis doesn't seem right. Missing Curly brackets:

=XIRR(Aggr(Only({<Company-={'ABC.'}>}Amount), Company), Date)

Re: Expression Help

Anonymous — Mon, 15 Feb 2016 16:46:48 GMT

Thanks Guys, still not working.

Re: Expression Help

cesaraccardi — Mon, 15 Feb 2016 16:51:27 GMT

Hi,

What if you write it like this:

xirr(total<Company> sum({$<Company-={'ABC.'}>} Amount), Date)

Cesar

Re: Expression Help

Anonymous — Mon, 15 Feb 2016 21:51:30 GMT

Didn't work.

Re: Expression Help

Anonymous — Mon, 15 Feb 2016 22:28:15 GMT

Pls provide error you get when trying the above suggested expressions. When using aggr we need to have an aggregation function. You must have did a thorough check I am sure, but just want to rule out any typos here, is it ABC. or ABC ?

Try this:

XIRR(Aggr(Sum({<Company-={"ABC*"}>}Amount), Company), Date)

Re: Expression Help

Anonymous — Tue, 16 Feb 2016 00:48:50 GMT

Thanks All for the replies.

I figure it out by removing Aggr and Sum from the above expression.