0 Replies Latest reply: Apr 30, 2015 1:37 PM by Paul Van Siclen RSS

    More on Time Value of Money - IRR

    Paul Van Siclen

      I recently created a Time Value of Money related application in Qlik Sense and sharing with the group.  The use case was to create a demonstration of dynamically calculating the Internal Rate of Return (IRR) across multiple dimensions to provide the user with the ability to slice and dice a portfolio.

       

      Spreadsheets and spreadsheet add-on's have trouble with this (as you know) but loading the data into Qlik completely simplifies the user experience, and is all driven by a minimal number of formulas.

       

      Old way:

       

       

      With Qlik: