topic Showing Correlation Coefficient in Chart same column in QlikView https://community.qlik.com/t5/QlikView/Showing-Correlation-Coefficient-in-Chart-same-column/m-p/673711#M244644 <HTML><HEAD></HEAD><BODY><P>In this thread <A href="https://community.qlik.com/thread/105532">Showing Correlation Coefficient in Chart</A> explain how calculating <STRONG>Correlation Coefficient i</STRONG>n QLikview:</P><H4 style="font-size: 12.800000190734863px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; background-color: #316ac5; color: #ffffff;">correl</SPAN><A name="kanchor1105" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"></A><A name="correl" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"></A> (<SPAN style="font-weight: inherit; font-style: italic; font-family: inherit;">[{set_expression}] [</SPAN> total <SPAN style="font-weight: inherit; font-style: italic; font-family: inherit;">[&lt;fld {,fld}&gt;] ] x-expression, y-expression </SPAN>)</H4><P></P><P>example:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD class="xl65" height="20" width="64">X</TD><TD class="xl65" style="border-left: none;" width="64">Y</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">18</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">13</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">17</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">15</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">15</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">14</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">16</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">13</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">14</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">9</TD></TR></TBODY></TABLE><P></P><P>Correl(<X>,<Y>) = 0.624037721</Y></X></P><P></P><P>But my data is this:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px;"><TBODY><TR><TD height="20" width="64">Metric</TD><TD width="64">Measure</TD></TR><TR><TD height="20">X</TD><TD class="xl65" width="64">18</TD></TR><TR><TD height="20">X</TD><TD class="xl65" style="border-top: none;" width="64">17</TD></TR><TR><TD height="20">X</TD><TD class="xl65" style="border-top: none;" width="64">15</TD></TR><TR><TD height="20">X</TD><TD class="xl65" style="border-top: none;" width="64">16</TD></TR><TR><TD height="20">X</TD><TD class="xl65" style="border-top: none;" width="64">14</TD></TR><TR><TD height="20">Y</TD><TD class="xl65" style="border-top: none;" width="64">13</TD></TR><TR><TD height="20">Y</TD><TD class="xl65" style="border-top: none;" width="64">15</TD></TR><TR><TD height="20">Y</TD><TD class="xl65" style="border-top: none;" width="64">14</TD></TR><TR><TD height="20">Y</TD><TD class="xl65" style="border-top: none;" width="64">13</TD></TR><TR><TD height="20">Y</TD><TD class="xl65" style="border-top: none;" width="64">9</TD></TR></TBODY></TABLE><P>How can calculate Correlation, if it show error: =Correl({$&lt;Metric={'X'}&gt;}Measure,{$&lt;Metric={'Y'}&gt;}Measure)</P><P></P><P>Thanks for your help</P></BODY></HTML> Wed, 22 Oct 2014 01:50:37 GMT 2014-10-22T01:50:37Z Showing Correlation Coefficient in Chart same column https://community.qlik.com/t5/QlikView/Showing-Correlation-Coefficient-in-Chart-same-column/m-p/673711#M244644 <HTML><HEAD></HEAD><BODY><P>In this thread <A href="https://community.qlik.com/thread/105532">Showing Correlation Coefficient in Chart</A> explain how calculating <STRONG>Correlation Coefficient i</STRONG>n QLikview:</P><H4 style="font-size: 12.800000190734863px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; background-color: #316ac5; color: #ffffff;">correl</SPAN><A name="kanchor1105" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"></A><A name="correl" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"></A> (<SPAN style="font-weight: inherit; font-style: italic; font-family: inherit;">[{set_expression}] [</SPAN> total <SPAN style="font-weight: inherit; font-style: italic; font-family: inherit;">[&lt;fld {,fld}&gt;] ] x-expression, y-expression </SPAN>)</H4><P></P><P>example:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD class="xl65" height="20" width="64">X</TD><TD class="xl65" style="border-left: none;" width="64">Y</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">18</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">13</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">17</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">15</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">15</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">14</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">16</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">13</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">14</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">9</TD></TR></TBODY></TABLE><P></P><P>Correl(<X>,<Y>) = 0.624037721</Y></X></P><P></P><P>But my data is this:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px;"><TBODY><TR><TD height="20" width="64">Metric</TD><TD width="64">Measure</TD></TR><TR><TD height="20">X</TD><TD class="xl65" width="64">18</TD></TR><TR><TD height="20">X</TD><TD class="xl65" style="border-top: none;" width="64">17</TD></TR><TR><TD height="20">X</TD><TD class="xl65" style="border-top: none;" width="64">15</TD></TR><TR><TD height="20">X</TD><TD class="xl65" style="border-top: none;" width="64">16</TD></TR><TR><TD height="20">X</TD><TD class="xl65" style="border-top: none;" width="64">14</TD></TR><TR><TD height="20">Y</TD><TD class="xl65" style="border-top: none;" width="64">13</TD></TR><TR><TD height="20">Y</TD><TD class="xl65" style="border-top: none;" width="64">15</TD></TR><TR><TD height="20">Y</TD><TD class="xl65" style="border-top: none;" width="64">14</TD></TR><TR><TD height="20">Y</TD><TD class="xl65" style="border-top: none;" width="64">13</TD></TR><TR><TD height="20">Y</TD><TD class="xl65" style="border-top: none;" width="64">9</TD></TR></TBODY></TABLE><P>How can calculate Correlation, if it show error: =Correl({$&lt;Metric={'X'}&gt;}Measure,{$&lt;Metric={'Y'}&gt;}Measure)</P><P></P><P>Thanks for your help</P></BODY></HTML> Wed, 22 Oct 2014 01:50:37 GMT https://community.qlik.com/t5/QlikView/Showing-Correlation-Coefficient-in-Chart-same-column/m-p/673711#M244644 2014-10-22T01:50:37Z Re: Showing Correlation Coefficient in Chart same column https://community.qlik.com/t5/QlikView/Showing-Correlation-Coefficient-in-Chart-same-column/m-p/673712#M244645 <HTML><HEAD></HEAD><BODY><P>I am also having this issue, can you use $ expansion to calculate correlations between specific measures? You should be able to.</P></BODY></HTML> Mon, 30 Apr 2018 20:53:44 GMT https://community.qlik.com/t5/QlikView/Showing-Correlation-Coefficient-in-Chart-same-column/m-p/673712#M244645 Anonymous 2018-04-30T20:53:44Z