Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Matrix multiplication

I'm trying to implement something to make a matrix multiplication.
I have two pivot table. The first is VaR pivot table:

VaR table.png

VaR table has as:
- used Dimension: Equity

- expression: Stdev([Countinuosly compounded return])* NORMINV(0.95,0,1) * Total_Investment_on_Each_Equity

The second pivot table is the Correlation table built using this thread Calculate correlation coefficient among all pairs of equities:correlationTable.png

Now my target is to make a matrix multiplication:
VaR(transposed) * Correlation.

3 Replies
sunny_talwar

Do you have a sample you can share with the kind of output you are looking for?

UPDATE: Sample alone should work

Not applicable
Author

Here we are.
In this project you can find two pivot table: the Value at risk and the correlation matrix.

Mi target is to make the matrix multiplication between the matrix of value at risk(transposed) and the correlation matrix.

P.S. I am not able to open qlikview file since I'm using a personal edition.

Thank you, again, for your kindness and patience.

sunny_talwar

Does this look right to you, number wise:

Capture.PNG

Expression:

=Correl([Adj Close], [_Adj Close]) * Stdev([Countinuosly compounded return]) * NORMINV(0.95,0,1) * Total_Inv

Dimensions:

Notice that I have swapped Equity and _Equity dimensions