Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

expression in text box to calculate xirr value

Hi all

can anyone help - what would be the expression to write as an input in text box for calculating xirr value by taking variables as input.

The two variables are var (holds payment) and var1 (holds date).

Any help would be deeply appreciated.

thanks

4 Replies
adamdavi3s
Honored Contributor

Re: expression in text box to calculate xirr value

Exclude my ignorance with the xirr formula as it's not something I have used before, but don't you need a range of data including income and payments to calculate it rather than one row?

Re: expression in text box to calculate xirr value

Can you share the variables please?

LET Var1 = Sum(Sales)

LET Var2 = Count(Sales)

If you want to calculate Average, Take Text object and use this

='The Average is' & ($(Var1) / $(Var2))

might be, We can help you if you really share those variables

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable

Re: expression in text box to calculate xirr value

we calculate xirr(amount,date)

where date is a filed name in script and amount is filed name in script

so how to find xirr when i have these two things in variables, what would be the expression?

Not applicable

Re: expression in text box to calculate xirr value

here i have attached the file

the variables are holding the amount and date, now i want to know the expression to find xirr using the values in variables.

Or is there any other way round, that wil also help.

thanks, any help would be appreciated