https://community.qlik.com/t5/QlikView/Average-Issue/m-p/1531248#M747768 <P>I'm relatively new to Qlik and stuck. I have a table that is created as a visualization. The table is giving me an auto generated average.</P><P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Table.jpg" style="width: 248px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3886iBC6D9BAB6A4BEF49/image-size/large?v=v2&amp;px=999" role="button" title="Table.jpg" alt="Table.jpg" /></span></P><P>When I try to create a KPI visualization for one of the fields in the table (using the same master item) I don't get the correct average that my table shows.&nbsp;</P><P>I'm taking the master item and in the function filed adding "Avg(field)" I've also tried changing it to "Sum(field)/Count(field)" either way it doesn't work. I do have "-" fields does that matter? What am I doing wrong?</P> Sat, 16 Nov 2024 04:44:20 GMT khammBostik 2024-11-16T04:44:20Z https://community.qlik.com/t5/QlikView/Average-Issue/m-p/1531248#M747768 <P>I'm relatively new to Qlik and stuck. I have a table that is created as a visualization. The table is giving me an auto generated average.</P><P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Table.jpg" style="width: 248px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3886iBC6D9BAB6A4BEF49/image-size/large?v=v2&amp;px=999" role="button" title="Table.jpg" alt="Table.jpg" /></span></P><P>When I try to create a KPI visualization for one of the fields in the table (using the same master item) I don't get the correct average that my table shows.&nbsp;</P><P>I'm taking the master item and in the function filed adding "Avg(field)" I've also tried changing it to "Sum(field)/Count(field)" either way it doesn't work. I do have "-" fields does that matter? What am I doing wrong?</P> Sat, 16 Nov 2024 04:44:20 GMT https://community.qlik.com/t5/QlikView/Average-Issue/m-p/1531248#M747768 khammBostik 2024-11-16T04:44:20Z https://community.qlik.com/t5/QlikView/Average-Issue/m-p/1531257#M747769 Hi,<BR /><BR />If you are using table with average as expression it will consider dimensions as well.<BR />If you are using KPI Object it will not consider and will give entire average. Please check with table dimensions.<BR /> Wed, 16 Jan 2019 20:43:03 GMT https://community.qlik.com/t5/QlikView/Average-Issue/m-p/1531257#M747769 Somasundaram 2019-01-16T20:43:03Z