topic Calculating Area Under a Scatter Plot in QlikView https://community.qlik.com/t5/QlikView/Calculating-Area-Under-a-Scatter-Plot/m-p/478331#M1139748 <HTML><HEAD></HEAD><BODY><P>I have the following values in a Scatter Plot X and Y. I need to calculate in Qlikview the area of all the rectangles using the included formula. The result should be 0.91. Any ideas?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="442"><TBODY><TR><TD class="xl63" height="17" width="39">Score</TD><TD class="xl63" style="border-left: none;" width="84">Scatter Plot X</TD><TD class="xl63" style="border-left: none;" width="84">Scatter Plot Y</TD><TD class="xl66" style="border-left: none;" width="119">Area of Scatter Plot</TD><TD class="xl66" style="border-left: none;" width="116">Formula</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.03</TD><TD>(C2+C3)/2*(B2-B3)</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.97</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.02</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.95</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.05</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.90</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.06</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.84</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.07</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">6</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.77</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.10</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">7</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.66</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.99</TD><TD class="xl67">0.08</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">8</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.58</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.99</TD><TD class="xl67">0.08</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">9</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.50</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.98</TD><TD class="xl67">0.09</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">10</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.41</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.97</TD><TD class="xl67">0.06</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">11</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.34</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.95</TD><TD class="xl67">0.04</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">12</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.31</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.94</TD><TD class="xl67">0.04</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">13</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.26</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.92</TD><TD class="xl67">0.06</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">14</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.19</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.86</TD><TD class="xl67">0.07</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.11</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.72</TD><TD class="xl67">0.04</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">16</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.05</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.53</TD><TD class="xl67">0.01</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">17</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.02</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.36</TD><TD class="xl67">0.00</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">18</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.01</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.23</TD><TD class="xl67">0.00</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">19</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.11</TD><TD class="xl67">0.00</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">20</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.06</TD><TD class="xl67">0.00</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">21</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00</TD><TD class="xl67">0.00</TD></TR><TR><TD height="17">Total</TD><TD class="xl67">0.91</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Sep 2013 16:19:48 GMT 2013-09-25T16:19:48Z Calculating Area Under a Scatter Plot https://community.qlik.com/t5/QlikView/Calculating-Area-Under-a-Scatter-Plot/m-p/478331#M1139748 <HTML><HEAD></HEAD><BODY><P>I have the following values in a Scatter Plot X and Y. I need to calculate in Qlikview the area of all the rectangles using the included formula. The result should be 0.91. Any ideas?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="442"><TBODY><TR><TD class="xl63" height="17" width="39">Score</TD><TD class="xl63" style="border-left: none;" width="84">Scatter Plot X</TD><TD class="xl63" style="border-left: none;" width="84">Scatter Plot Y</TD><TD class="xl66" style="border-left: none;" width="119">Area of Scatter Plot</TD><TD class="xl66" style="border-left: none;" width="116">Formula</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.03</TD><TD>(C2+C3)/2*(B2-B3)</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.97</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.02</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.95</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.05</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.90</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.06</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.84</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.07</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">6</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.77</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1.00</TD><TD class="xl67">0.10</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">7</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.66</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.99</TD><TD class="xl67">0.08</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">8</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.58</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.99</TD><TD class="xl67">0.08</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">9</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.50</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.98</TD><TD class="xl67">0.09</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">10</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.41</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.97</TD><TD class="xl67">0.06</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">11</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.34</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.95</TD><TD class="xl67">0.04</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">12</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.31</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.94</TD><TD class="xl67">0.04</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">13</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.26</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.92</TD><TD class="xl67">0.06</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">14</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.19</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.86</TD><TD class="xl67">0.07</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.11</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.72</TD><TD class="xl67">0.04</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">16</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.05</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.53</TD><TD class="xl67">0.01</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">17</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.02</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.36</TD><TD class="xl67">0.00</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">18</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.01</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.23</TD><TD class="xl67">0.00</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">19</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.11</TD><TD class="xl67">0.00</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">20</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.06</TD><TD class="xl67">0.00</TD></TR><TR><TD align="right" class="xl64" height="17" style="border-top: none;">21</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0.00</TD><TD class="xl67">0.00</TD></TR><TR><TD height="17">Total</TD><TD class="xl67">0.91</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Sep 2013 16:19:48 GMT https://community.qlik.com/t5/QlikView/Calculating-Area-Under-a-Scatter-Plot/m-p/478331#M1139748 2013-09-25T16:19:48Z Re: Calculating Area Under a Scatter Plot https://community.qlik.com/t5/QlikView/Calculating-Area-Under-a-Scatter-Plot/m-p/478332#M1139749 <HTML><HEAD></HEAD><BODY><P>Here you are attached.</P></BODY></HTML> Wed, 25 Sep 2013 17:32:42 GMT https://community.qlik.com/t5/QlikView/Calculating-Area-Under-a-Scatter-Plot/m-p/478332#M1139749 2013-09-25T17:32:42Z Re: Calculating Area Under a Scatter Plot https://community.qlik.com/t5/QlikView/Calculating-Area-Under-a-Scatter-Plot/m-p/478333#M1139750 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA,</P><P></P><P>Regards</P></BODY></HTML> Wed, 25 Sep 2013 17:45:18 GMT https://community.qlik.com/t5/QlikView/Calculating-Area-Under-a-Scatter-Plot/m-p/478333#M1139750 v_iyyappan 2013-09-25T17:45:18Z