https://community.qlik.com/t5/QlikView/Creating-Scatter-Chart/m-p/1530680#M748435 <P>Hello Qlikers,</P><P>I have a question how to create a scatter chart with calculated dimension which is an average value of QoI for each stock number. I want to create a scatter chart&nbsp; in QV as it shown below which was created using an excel . It is an AVERAGEIF function that calculates the average QoI value for each stock number across all items. This table is what I want to plot overtime.</P><P>Thanks for your help</P><P>Wossen</P><TABLE><TBODY><TR><TD>Stock Number</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD><TD>7</TD><TD>8</TD><TD>9</TD><TD>10</TD><TD>11</TD><TD>12</TD><TD>13</TD><TD>14</TD><TD>15</TD><TD>16</TD><TD>17</TD><TD>18</TD><TD>19</TD><TD>20</TD><TD>21</TD><TD>22</TD><TD>23</TD><TD>24</TD><TD>25</TD></TR><TR><TD>Average</TD><TD>4.25618</TD><TD>4.16307</TD><TD>4.130081</TD><TD>4.12</TD><TD>4.130719</TD><TD>4.09894</TD><TD>4.171315</TD><TD>4.137931</TD><TD>4.137755</TD><TD>4.132184</TD><TD>4.131034</TD><TD>3.985185</TD><TD>4.05042</TD><TD>4.09375</TD><TD>4.22807</TD><TD>4.258065</TD><TD>4.384615</TD><TD>4.583333</TD><TD>4.6</TD><TD>5</TD><TD>4.666667</TD><TD>4.166667</TD><TD>4.75</TD><TD>4</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Schart.png" style="width: 895px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3798iA0600358AFF7E932/image-size/large?v=v2&amp;px=999" role="button" title="Schart.png" alt="Schart.png" /></span></P> Wed, 25 Nov 2020 16:16:04 GMT wossenhh 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Creating-Scatter-Chart/m-p/1530680#M748435 <P>Hello Qlikers,</P><P>I have a question how to create a scatter chart with calculated dimension which is an average value of QoI for each stock number. I want to create a scatter chart&nbsp; in QV as it shown below which was created using an excel . It is an AVERAGEIF function that calculates the average QoI value for each stock number across all items. This table is what I want to plot overtime.</P><P>Thanks for your help</P><P>Wossen</P><TABLE><TBODY><TR><TD>Stock Number</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD><TD>7</TD><TD>8</TD><TD>9</TD><TD>10</TD><TD>11</TD><TD>12</TD><TD>13</TD><TD>14</TD><TD>15</TD><TD>16</TD><TD>17</TD><TD>18</TD><TD>19</TD><TD>20</TD><TD>21</TD><TD>22</TD><TD>23</TD><TD>24</TD><TD>25</TD></TR><TR><TD>Average</TD><TD>4.25618</TD><TD>4.16307</TD><TD>4.130081</TD><TD>4.12</TD><TD>4.130719</TD><TD>4.09894</TD><TD>4.171315</TD><TD>4.137931</TD><TD>4.137755</TD><TD>4.132184</TD><TD>4.131034</TD><TD>3.985185</TD><TD>4.05042</TD><TD>4.09375</TD><TD>4.22807</TD><TD>4.258065</TD><TD>4.384615</TD><TD>4.583333</TD><TD>4.6</TD><TD>5</TD><TD>4.666667</TD><TD>4.166667</TD><TD>4.75</TD><TD>4</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Schart.png" style="width: 895px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3798iA0600358AFF7E932/image-size/large?v=v2&amp;px=999" role="button" title="Schart.png" alt="Schart.png" /></span></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Creating-Scatter-Chart/m-p/1530680#M748435 wossenhh 2020-11-25T16:16:04Z