topic Re: plotting correlation line on scatter chart in QlikView https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382762#M571508 <HTML><HEAD></HEAD><BODY><P>haha thanks! </P><P>Or I could draw it on a chalkboard and scribble on it <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P><P></P><P>It's driving me nuts, it must be possible to do it somehow... but I am stuck even calculating the overall correlation coeficient which would be a start!</P></BODY></HTML> Fri, 31 Aug 2012 12:52:46 GMT adamdavi3s 2012-08-31T12:52:46Z plotting correlation line on scatter chart https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382760#M571506 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am a bit lost with this. I am simply trying to create a scatter chart showing the correlation between two expense types per dimension.</P><P></P><P>E.g.</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="97" style="border: 1px solid rgb(0, 0, 0); width: 387px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">Episode</TH><TH align="center" style="background-color: #6690bc;" valign="middle">cost_a</TH><TH align="center" style="background-color: #6690bc;" valign="middle">cost_b</TH></TR><TR><TD style="text-align: center;">1</TD><TD style="text-align: center;">10</TD><TD style="text-align: center;">10</TD></TR><TR><TD style="text-align: center;">2</TD><TD style="text-align: center;">20</TD><TD style="text-align: center;">25</TD></TR><TR><TD style="text-align: center;">3</TD><TD style="text-align: center;">15</TD><TD style="text-align: center;">6</TD></TR></TBODY></TABLE><P>Obviously creating the scatter chart is easy, however I can't seem to get the correlation line to show... I have tried using correl and rangecorrel but I think I must be using them incorrectly.</P><P></P><P>I would be happy if I could plot this as a separate transparent chart over the top but I am a bit clueless as to how to achieve this!</P><P></P><P>Example attached</P></BODY></HTML> Fri, 31 Aug 2012 07:27:03 GMT https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382760#M571506 adamdavi3s 2012-08-31T07:27:03Z Re: plotting correlation line on scatter chart https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382761#M571507 <HTML><HEAD></HEAD><BODY><P>Yeah, thats a problem.</P><P></P><P>As a workaround you can use a prepeared background image with diagonal line <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P>Of course , you have to normalize your chart values/axis.</P></BODY></HTML> Fri, 31 Aug 2012 12:50:12 GMT https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382761#M571507 whiteline 2012-08-31T12:50:12Z Re: plotting correlation line on scatter chart https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382762#M571508 <HTML><HEAD></HEAD><BODY><P>haha thanks! </P><P>Or I could draw it on a chalkboard and scribble on it <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P><P></P><P>It's driving me nuts, it must be possible to do it somehow... but I am stuck even calculating the overall correlation coeficient which would be a start!</P></BODY></HTML> Fri, 31 Aug 2012 12:52:46 GMT https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382762#M571508 adamdavi3s 2012-08-31T12:52:46Z Re: plotting correlation line on scatter chart https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382763#M571509 <HTML><HEAD></HEAD><BODY><P>Ok,</P><P>If you find the solution without background image or placing other objects over or behind the chart please,</P><P>post it here. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I think you've already tried reference lines...</P></BODY></HTML> Fri, 31 Aug 2012 13:26:33 GMT https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382763#M571509 whiteline 2012-08-31T13:26:33Z Re: plotting correlation line on scatter chart https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382764#M571510 <HTML><HEAD></HEAD><BODY><P>I will eventually... even if it kills me!</P></BODY></HTML> Fri, 31 Aug 2012 14:30:27 GMT https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382764#M571510 adamdavi3s 2012-08-31T14:30:27Z Re: plotting correlation line on scatter chart https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382765#M571511 <HTML><HEAD></HEAD><BODY><P>Here</P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/thread/60208?tstart=0" title="http://community.qlik.com/thread/60208?tstart=0">http://community.qlik.com/thread/60208?tstart=0</A></P><P>Daniel's suggested elegant solution.</P></BODY></HTML> Mon, 10 Sep 2012 04:26:59 GMT https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382765#M571511 whiteline 2012-09-10T04:26:59Z Re: plotting correlation line on scatter chart https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382766#M571512 <HTML><HEAD></HEAD><BODY><P>It was simply a case of a linear reference line in the end... I wanted to calculate it in a table as well which is where all my confusion was coming in I think!</P><P></P><P>You can literally include expression 1 and expression 2, then apply the linear flag to the expression 2 which gives a good enough idea of correlation at a glance!</P></BODY></HTML> Mon, 10 Sep 2012 07:16:49 GMT https://community.qlik.com/t5/QlikView/plotting-correlation-line-on-scatter-chart/m-p/382766#M571512 adamdavi3s 2012-09-10T07:16:49Z