Discussion board where members can get started with QlikView.
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.
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?
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
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?
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