Problem financial function 'Rate'.

rogeriobarbosa — Wed, 04 Jan 2012 17:22:34 GMT

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

Problem financial function 'Rate'.

swuehl — Wed, 04 Jan 2012 23:27:55 GMT

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())),

sum(TOTAL ALL META) - RangeSum(above(sum(VENDA),0,RowNo())),

)

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

topic Problem financial function 'Rate'. in QlikView

Problem financial function 'Rate'.

Problem financial function 'Rate'.