Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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