https://community.qlik.com/t5/QlikView/Calculating-my-IRR-to-plot-it/m-p/1728442#M452164 <P>Do you have a sample where you have been trying it? It might be easier to look at a sample where we can work to get the output you are hoping to get</P> Thu, 16 Jul 2020 12:50:36 GMT sunny_talwar 2020-07-16T12:50:36Z https://community.qlik.com/t5/QlikView/Calculating-my-IRR-to-plot-it/m-p/1728324#M452150 <P>Hi all,</P><P>I will be incredibly impressed if some one is able to help me on this one!</P><P>I am trying to plot my actual IRR for my BMW book .&nbsp;</P><P>My net 'cashflows' are currently calculated as:</P><P><EM>sum({$&lt;[Trans Type]= {R},Client = {'BMW'} &gt;} Amount)*0.75</EM></P><P>I have a date variable called <EM>monthyear</EM></P><P>and lets say the cost is R20 000 000 which is imported as&nbsp;[BMW&nbsp; C] from the Costs table.</P><P>PLEASE, help we with the expression or any other suggestions of how to go about it. I thought of trying to create a variable with my cashflows but my code was unsuccessful. I am still new to QllikVIew so please excuse me if I am making a stupid mistake. I know there is an IRR formula but I don't know how to get my cashflows in the correct form to perform it. Please just ask if you need anymore information</P><P>Thank you greatly in advance</P> Sat, 16 Nov 2024 18:21:25 GMT https://community.qlik.com/t5/QlikView/Calculating-my-IRR-to-plot-it/m-p/1728324#M452150 James17Martin1 2024-11-16T18:21:25Z https://community.qlik.com/t5/QlikView/Calculating-my-IRR-to-plot-it/m-p/1728442#M452164 <P>Do you have a sample where you have been trying it? It might be easier to look at a sample where we can work to get the output you are hoping to get</P> Thu, 16 Jul 2020 12:50:36 GMT https://community.qlik.com/t5/QlikView/Calculating-my-IRR-to-plot-it/m-p/1728442#M452164 sunny_talwar 2020-07-16T12:50:36Z