topic FVSCHEDULE equivalent in Qlikview in QlikView https://community.qlik.com/t5/QlikView/FVSCHEDULE-equivalent-in-Qlikview/m-p/956636#M328685 <HTML><HEAD></HEAD><BODY><P>Hi Gurus,</P><P></P><P>I would like to calculate</P><P>FVSchedule,</P><P>Tacking error,</P><P>Information ratio</P><P>Sharpe Ration</P><P>Beta,</P><P>In qlikview, Does anyone know how to calculate them in QV.</P><P></P><P>Thanks.</P><P>RK</P></BODY></HTML> Tue, 29 Sep 2015 08:26:16 GMT rkondaveti 2015-09-29T08:26:16Z FVSCHEDULE equivalent in Qlikview https://community.qlik.com/t5/QlikView/FVSCHEDULE-equivalent-in-Qlikview/m-p/956636#M328685 <HTML><HEAD></HEAD><BODY><P>Hi Gurus,</P><P></P><P>I would like to calculate</P><P>FVSchedule,</P><P>Tacking error,</P><P>Information ratio</P><P>Sharpe Ration</P><P>Beta,</P><P>In qlikview, Does anyone know how to calculate them in QV.</P><P></P><P>Thanks.</P><P>RK</P></BODY></HTML> Tue, 29 Sep 2015 08:26:16 GMT https://community.qlik.com/t5/QlikView/FVSCHEDULE-equivalent-in-Qlikview/m-p/956636#M328685 rkondaveti 2015-09-29T08:26:16Z Re: FVSCHEDULE equivalent in Qlikview https://community.qlik.com/t5/QlikView/FVSCHEDULE-equivalent-in-Qlikview/m-p/956637#M328686 <HTML><HEAD></HEAD><BODY><P>Have a look on the qlikview help by finance functions, for example:</P><P></P><P><SPAN class="Bold">fv(</SPAN><SPAN class="Italic">rate, nper, pmt [ ,pv [ , typ ] ]</SPAN><SPAN class="Bold">)</SPAN></P><P></P><P>- Marcus</P></BODY></HTML> Tue, 29 Sep 2015 13:06:42 GMT https://community.qlik.com/t5/QlikView/FVSCHEDULE-equivalent-in-Qlikview/m-p/956637#M328686 marcus_sommer 2015-09-29T13:06:42Z Re: FVSCHEDULE equivalent in Qlikview https://community.qlik.com/t5/QlikView/FVSCHEDULE-equivalent-in-Qlikview/m-p/956638#M328687 <HTML><HEAD></HEAD><BODY><P>Please find the below Help Info:</P><P></P><P class="syntax"><A name="kanchor677"></A><A name="fv"></A><SPAN class="Bold">fv(</SPAN><SPAN class="Italic">rate, nper, pmt [ ,pv [ , type ] ]</SPAN><SPAN class="Bold">)</SPAN> </P><P>Returns the future value of an investment based on periodic, constant payments and a constant interest rate. The result has a default number format of <A class="MCXref_0"><EM>Money</EM></A>. </P><P class="example">Example:</P><P>You are paying a new VCR by 36 monthly installments of $20. The interest rate is 6% per annum. The bill comes at the end of every month. What is the total value of the money invested, when the last bill has been paid?</P><P><SPAN class="Code">fv(0.005,36,-20)</SPAN> returns $786.72 </P></BODY></HTML> Tue, 29 Sep 2015 13:15:52 GMT https://community.qlik.com/t5/QlikView/FVSCHEDULE-equivalent-in-Qlikview/m-p/956638#M328687 2015-09-29T13:15:52Z