topic Re: Matrix in QlikView https://community.qlik.com/t5/QlikView/Matrix/m-p/476526#M1136774 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is anyone able to assist with this query?&nbsp; Any help/or advice would be great.</P><P></P><P>Thanks,</P><P>Daniel</P><P><BR /> </P></BODY></HTML> Tue, 05 Nov 2013 10:44:32 GMT danielnevitt 2013-11-05T10:44:32Z Matrix https://community.qlik.com/t5/QlikView/Matrix/m-p/476525#M1136773 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to replicate a matrix calculation I have in Excel in Qlikview.</P><P></P><P>The attached excel sheet shows the matrix calculation.</P><P></P><P>Overview of the excel matrix:</P><P><SPAN style="font-size: 10pt; font-family: Helv;">&nbsp; </SPAN></P><P dir="ltr">- Start by defining your spreads in terms of your outrights (Matrix 1)</P><P></P><P dir="ltr">- Then calculate the inverse (Matrix 2)</P><P></P><P dir="ltr">- To get from an outright position (Input) to a spread position (Output1), simply post-multiply the Input by Matrix2.</P><P></P><P>- To sense check, you can get back to an outright view (Output2) by post-multiplying your spread view (Output1) by Matrix1.</P><P> </P><P><SPAN style="font-size: 10pt; font-family: Helv;">Hope the above makes sense.&nbsp; Any help with this will be much appreciated.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt; font-family: Helv;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Helv;">Daniel</SPAN></P><P> </P></BODY></HTML> Mon, 04 Nov 2013 12:08:23 GMT https://community.qlik.com/t5/QlikView/Matrix/m-p/476525#M1136773 danielnevitt 2013-11-04T12:08:23Z Re: Matrix https://community.qlik.com/t5/QlikView/Matrix/m-p/476526#M1136774 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is anyone able to assist with this query?&nbsp; Any help/or advice would be great.</P><P></P><P>Thanks,</P><P>Daniel</P><P><BR /> </P></BODY></HTML> Tue, 05 Nov 2013 10:44:32 GMT https://community.qlik.com/t5/QlikView/Matrix/m-p/476526#M1136774 danielnevitt 2013-11-05T10:44:32Z