topic Re: Qlikview Pivot chart Avg() for distinct records in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Pivot-chart-Avg-for-distinct-records/m-p/913616#M988792 <HTML><HEAD></HEAD><BODY><P>Try as expression:</P><P></P><P>=Avg( Aggr( LT, plnt, mat))</P></BODY></HTML> Fri, 24 Jul 2015 10:22:13 GMT swuehl 2015-07-24T10:22:13Z Qlikview Pivot chart Avg() for distinct records https://community.qlik.com/t5/QlikView/Qlikview-Pivot-chart-Avg-for-distinct-records/m-p/913615#M988791 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have an internal table with records. <SPAN style="font-size: 10pt; line-height: 1.5em;">For reasons I should keep duplicated records with different IDs. But I'm NOT able to get expected average LT. How to <SPAN style="font-size: 13.3333330154419px;">get average for a shared dimension (plnt) using </SPAN><STRONG style="font-size: 13.3333330154419px;">Pivot Chart</STRONG><SPAN style="font-size: 13.3333330154419px;"> and </SPAN><STRONG style="font-size: 13.3333330154419px;">Avg()?</STRONG></SPAN></P><P></P><P>qvw file is attached for your kind help.</P><P><IMG alt="testAvg1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/93878_testAvg1.png" style="height: auto;" /></P></BODY></HTML> Fri, 24 Jul 2015 10:07:11 GMT https://community.qlik.com/t5/QlikView/Qlikview-Pivot-chart-Avg-for-distinct-records/m-p/913615#M988791 2015-07-24T10:07:11Z Re: Qlikview Pivot chart Avg() for distinct records https://community.qlik.com/t5/QlikView/Qlikview-Pivot-chart-Avg-for-distinct-records/m-p/913616#M988792 <HTML><HEAD></HEAD><BODY><P>Try as expression:</P><P></P><P>=Avg( Aggr( LT, plnt, mat))</P></BODY></HTML> Fri, 24 Jul 2015 10:22:13 GMT https://community.qlik.com/t5/QlikView/Qlikview-Pivot-chart-Avg-for-distinct-records/m-p/913616#M988792 swuehl 2015-07-24T10:22:13Z Re: Qlikview Pivot chart Avg() for distinct records https://community.qlik.com/t5/QlikView/Qlikview-Pivot-chart-Avg-for-distinct-records/m-p/913617#M988793 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please check attached QVW ...&nbsp; I hope issue is resolved in it.</P><P></P><P>--</P><P>Regards,</P><P>Prashant P Baste</P></BODY></HTML> Fri, 24 Jul 2015 10:22:56 GMT https://community.qlik.com/t5/QlikView/Qlikview-Pivot-chart-Avg-for-distinct-records/m-p/913617#M988793 prashantbaste 2015-07-24T10:22:56Z Re: Qlikview Pivot chart Avg() for distinct records https://community.qlik.com/t5/QlikView/Qlikview-Pivot-chart-Avg-for-distinct-records/m-p/913618#M988794 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333330154419px;">Thanks swuehl</SPAN>, it works. </P><P>The solution can also be Avg(aggr(LT,mat))</P></BODY></HTML> Fri, 24 Jul 2015 14:31:30 GMT https://community.qlik.com/t5/QlikView/Qlikview-Pivot-chart-Avg-for-distinct-records/m-p/913618#M988794 2015-07-24T14:31:30Z