Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I have problems using the RATE function in QlikView, use the same function in Excel with the same values against different results, anyone know if the QLIK have any restrictions on financial functions.
follows the example files
Well, honestly, I don't know what you are calculating here per line, so I concentrated on the function syntax itself:
Please note that your excel function shows an ommited third parameter (two semicolons directly following each other). So you are using the 5 parameter version of the Excel function.
The QV function takes 3-5 parameter, so we need to enter all five. Since your Excel file doesn't show the cash equivalent as third parameter, I assumed zero for the QV function.
= rate(
12-INDICE_MES,
-RangeAvg(above(sum(VENDA),0,RowNo())),
0,
sum(TOTAL ALL META) - RangeSum(above(sum(VENDA),0,RowNo())),
1
)
And voila, I get the exact same numbers like in the excel file (after removing the minus sign before rate from your original expression).
Regards,
Stefan