https://community.qlik.com/t5/QlikView/Average-in-aggregate-function/m-p/1507174#M751290 <P>Averages can get a little tricky... check this out</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654" target="_blank">Average - Which average?</A></P> Thu, 15 Nov 2018 12:46:47 GMT sunny_talwar 2018-11-15T12:46:47Z https://community.qlik.com/t5/QlikView/Average-in-aggregate-function/m-p/1506959#M751289 <P>Hi guys,</P><P>&nbsp;</P><P>I am new to cliq sense and I am currently struggling with one formula.</P><P>I would like to calculate average number of expenses (ID) per grade of employee a per year quarter. I think the trouble is with the function agr - because if I switch it for max function for example it does calculate maximum number an employee in a particular grade posted per a particular quarter.</P><P>Could please anyone advise me what am I doing wrong??</P><P>aggr({&lt;NAME_ANONYMISED=&gt;} nodistinct <FONT color="#FF0000">avg</FONT>(aggr({&lt;NAME_ANONYMISED=&gt;}nodistinct count(ID),NAME_ANONYMISED, [POST_DATE.autoCalendar.YearQuarter])), GRADE,[POST_DATE.autoCalendar.YearQuarter])</P><P>&nbsp;</P><P>P.S.: the name anonymised is there in order to prevent qlik recalculating based on a name I select - this I would like to keep there. The average should not change with a filtered employee.</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Average-in-aggregate-function/m-p/1506959#M751289 Anonymous 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Average-in-aggregate-function/m-p/1507174#M751290 <P>Averages can get a little tricky... check this out</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654" target="_blank">Average - Which average?</A></P> Thu, 15 Nov 2018 12:46:47 GMT https://community.qlik.com/t5/QlikView/Average-in-aggregate-function/m-p/1507174#M751290 sunny_talwar 2018-11-15T12:46:47Z