topic Re: Has anyone worked with Financial Historical Performance – Cumulative Returns of Funds, Indexes, Accounts – I need help… in QlikView

Has anyone worked with Financial Historical Performance – Cumulative Returns of Funds, Indexes, Accounts – I need help…

Anonymous — Tue, 08 May 2018 19:12:00 GMT

Hi all,

The context: Historical Performance – Cumulative Returns of Funds, Indexes, Accounts or a combination of them:

I am developing an application the show the financial performance of Accounts (could be portfolios or Funds makes no difference. On the second tab I have a straight table showing the entire historical performance based on the user selections. The main selections are the Star and End Dates that define the date range tor the Series Calculation on the expressions on the table and the Account Name or multiple account names selected. The ideal would be able to drill down to the CUSIP level....

The Roadblock where I need help:

I need only to show the last row for the end date on these calculations on a separate straight table (or text boxes alternatively)to be displayed like this:

And later, add volatility like this:

Constrain:

All this needs to be done dynamically no at the LOAD time in the script.

I have attached a test QVW for you to have the opportunity to test, show and share with all of us your solution. Data was Scramble for obvious reasons and script was also removed from the QVW

Thanks …

Miguel

Re: Has anyone worked with Financial Historical Performance – Cumulative Returns of Funds, Indexes, Accounts – I need help…

sunny_talwar — Tue, 08 May 2018 19:26:40 GMT

Are the above expected output for a specific expression or are they random numbers you posted in the screenshot above?

Re: Has anyone worked with Financial Historical Performance – Cumulative Returns of Funds, Indexes, Accounts – I need help…

Anonymous — Wed, 09 May 2018 02:08:36 GMT

The two images – screenshots are just filled with sample numbers for illustration purposes. They are not expected results.

Re: Has anyone worked with Financial Historical Performance – Cumulative Returns of Funds, Indexes, Accounts – I need help…

sunny_talwar — Wed, 09 May 2018 02:29:03 GMT

Would you be able to provide the expected output from the sample you have provided?

Re: Has anyone worked with Financial Historical Performance – Cumulative Returns of Funds, Indexes, Accounts – I need help…

Anonymous — Wed, 09 May 2018 14:12:30 GMT

Sunny,

For the QVW attache originally and these "Current Selections" shown below:

The expected results will be a single row as of 3/10/2017 (End Date on the Date Range selected)… preferable in a straight table, alternatively, we could build the presentation with Text Boxes that hold each heading and each value and put them in a container.

Re: Has anyone worked with Financial Historical Performance – Cumulative Returns of Funds, Indexes, Accounts – I need help…

sunny_talwar — Wed, 09 May 2018 14:25:06 GMT

Multiply your expressions with this

* Avg({$<CalendarDate={"$(=Date(vSliderMaxDate))"}>} 1)

Re: Has anyone worked with Financial Historical Performance – Cumulative Returns of Funds, Indexes, Accounts – I need help…

Anonymous — Wed, 09 May 2018 17:24:23 GMT

Sunny,

Thank you!

Could you please tell in words what this is doing and why does it work?

* Avg({$<CalendarDate={"$(=Date(vSliderMaxDate))"}>} 1)

Thanks again.

Miguel

Re: Has anyone worked with Financial Historical Performance – Cumulative Returns of Funds, Indexes, Accounts – I need help…

sunny_talwar — Wed, 09 May 2018 17:38:07 GMT

All it is doing is making the max date stay using the set analysis which tells the Avg(1) to be 1 when max date and 0 when not the max date. So, multiplying by 0 makes all the rows 0 expect the max date.

Does this make sense?