topic Re: Correlation calculation in QlikView https://community.qlik.com/t5/QlikView/Correlation-calculation/m-p/1138466#M521875 <HTML><HEAD></HEAD><BODY><P>Maybe something like</P><P></P><P>=correl( Aggr( Only({&lt;Fundname = {$(vFundA)}&gt;} value), date), <SPAN style="font-size: 13.3333px;">Aggr( Only(<SPAN style="font-size: 13.3333px;">{&lt;Fundname = {$(vFundB)}&gt;} </SPAN>value), date) )</SPAN></P></BODY></HTML> Fri, 17 Jun 2016 10:42:49 GMT swuehl 2016-06-17T10:42:49Z Correlation calculation https://community.qlik.com/t5/QlikView/Correlation-calculation/m-p/1138465#M521874 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello all,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a table with 3 columns: Fundname, date and value. I have created two variables so you can input the name of the fund and I would like to calculate correlation between the variable value of any two funds. Please note that as the data of all the funds is merged in the same table, I cannot use directly the function correl, I would have to create a temporary table using the function aggr (I guess), but I don't know how to do it.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Anyone could help?</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks a lot!</P></BODY></HTML> Fri, 17 Jun 2016 10:05:17 GMT https://community.qlik.com/t5/QlikView/Correlation-calculation/m-p/1138465#M521874 2016-06-17T10:05:17Z Re: Correlation calculation https://community.qlik.com/t5/QlikView/Correlation-calculation/m-p/1138466#M521875 <HTML><HEAD></HEAD><BODY><P>Maybe something like</P><P></P><P>=correl( Aggr( Only({&lt;Fundname = {$(vFundA)}&gt;} value), date), <SPAN style="font-size: 13.3333px;">Aggr( Only(<SPAN style="font-size: 13.3333px;">{&lt;Fundname = {$(vFundB)}&gt;} </SPAN>value), date) )</SPAN></P></BODY></HTML> Fri, 17 Jun 2016 10:42:49 GMT https://community.qlik.com/t5/QlikView/Correlation-calculation/m-p/1138466#M521875 swuehl 2016-06-17T10:42:49Z Re: Correlation calculation https://community.qlik.com/t5/QlikView/Correlation-calculation/m-p/1138467#M521876 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">It worked!</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Do you think it would be possible creating an straight table so there would be a row for each fundname, and computing the correlation entering a single fundname? If so, how would you do it?</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks in advance!</P></BODY></HTML> Fri, 17 Jun 2016 11:05:19 GMT https://community.qlik.com/t5/QlikView/Correlation-calculation/m-p/1138467#M521876 2016-06-17T11:05:19Z Re: Correlation calculation https://community.qlik.com/t5/QlikView/Correlation-calculation/m-p/1138468#M521877 <HTML><HEAD></HEAD><BODY><P>Maybe something similar to what is shown in</P><P><A href="https://community.qlik.com/message/1019508">Calculate correlation coefficient among all pairs of equities</A></P></BODY></HTML> Fri, 17 Jun 2016 11:10:44 GMT https://community.qlik.com/t5/QlikView/Correlation-calculation/m-p/1138468#M521877 swuehl 2016-06-17T11:10:44Z