topic Correl with variables, calculated as an aggregate in QlikView https://community.qlik.com/t5/QlikView/Correl-with-variables-calculated-as-an-aggregate/m-p/397368#M148013 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'd like to calculate the correlation coefficient of two variables when their value is calculated at an aggregated by "Gorup Name" .I have tried the following expression however I get all nul values. I have tried using the Group Name as a dimension too and also tried removing it. I know the variables themselves do work as I am plotting them on a scatter chart and I can see valid values. Ultimately, I want a single number to tell me what the correlation coefficient is for the two variables that can be seen in the scatter graph.</P><P></P><P>correl <SPAN style="font-size: 8pt;">(&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Group Name]</SPAN><SPAN style="font-size: 8pt;">&gt;</SPAN><STRONG style="color: #808080; font-size: 8pt;"><EM>vExpression_scatterX</EM></STRONG><SPAN style="font-size: 8pt;">, vExpression_scatterY) </SPAN></P><P><SPAN style="font-size: 8pt;">or</SPAN></P><P>correl<SPAN style="font-size: 8pt;">(&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Group Name]</SPAN><SPAN style="font-size: 8pt;">&gt;</SPAN><STRONG style="color: #808080; font-size: 8pt;"><EM>$(vExpression_scatterX)</EM></STRONG><SPAN style="font-size: 8pt;">, </SPAN><STRONG style="color: #808080; font-size: 8pt;"><EM>$(vExpression_scatterY)</EM></STRONG><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P></P><P>Hopefully this is quite a simple one to fix... we shall see!</P><P></P><P>Many thanks,</P><P>Isabel </P></BODY></HTML> Wed, 22 May 2013 17:31:34 GMT 2013-05-22T17:31:34Z Correl with variables, calculated as an aggregate https://community.qlik.com/t5/QlikView/Correl-with-variables-calculated-as-an-aggregate/m-p/397368#M148013 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'd like to calculate the correlation coefficient of two variables when their value is calculated at an aggregated by "Gorup Name" .I have tried the following expression however I get all nul values. I have tried using the Group Name as a dimension too and also tried removing it. I know the variables themselves do work as I am plotting them on a scatter chart and I can see valid values. Ultimately, I want a single number to tell me what the correlation coefficient is for the two variables that can be seen in the scatter graph.</P><P></P><P>correl <SPAN style="font-size: 8pt;">(&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Group Name]</SPAN><SPAN style="font-size: 8pt;">&gt;</SPAN><STRONG style="color: #808080; font-size: 8pt;"><EM>vExpression_scatterX</EM></STRONG><SPAN style="font-size: 8pt;">, vExpression_scatterY) </SPAN></P><P><SPAN style="font-size: 8pt;">or</SPAN></P><P>correl<SPAN style="font-size: 8pt;">(&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Group Name]</SPAN><SPAN style="font-size: 8pt;">&gt;</SPAN><STRONG style="color: #808080; font-size: 8pt;"><EM>$(vExpression_scatterX)</EM></STRONG><SPAN style="font-size: 8pt;">, </SPAN><STRONG style="color: #808080; font-size: 8pt;"><EM>$(vExpression_scatterY)</EM></STRONG><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P></P><P>Hopefully this is quite a simple one to fix... we shall see!</P><P></P><P>Many thanks,</P><P>Isabel </P></BODY></HTML> Wed, 22 May 2013 17:31:34 GMT https://community.qlik.com/t5/QlikView/Correl-with-variables-calculated-as-an-aggregate/m-p/397368#M148013 2013-05-22T17:31:34Z