topic Re: Average on Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Average-on-Set-Analysis/m-p/938771#M323943 <HTML><HEAD></HEAD><BODY><P>=Avg({&lt;status = {'A'}&gt;} score)</P></BODY></HTML> Thu, 19 Nov 2015 14:26:16 GMT swuehl 2015-11-19T14:26:16Z Average on Set Analysis https://community.qlik.com/t5/QlikView/Average-on-Set-Analysis/m-p/938770#M323942 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I want to get avg on set analysis.</P><P>I have 2 fields, <STRONG>score</STRONG> and <STRONG>status</STRONG>, now I want to calculate an average of score when the status = A on set analysis.</P><P></P><P>Much appreciated!</P></BODY></HTML> Thu, 19 Nov 2015 08:21:21 GMT https://community.qlik.com/t5/QlikView/Average-on-Set-Analysis/m-p/938770#M323942 2015-11-19T08:21:21Z Re: Average on Set Analysis https://community.qlik.com/t5/QlikView/Average-on-Set-Analysis/m-p/938771#M323943 <HTML><HEAD></HEAD><BODY><P>=Avg({&lt;status = {'A'}&gt;} score)</P></BODY></HTML> Thu, 19 Nov 2015 14:26:16 GMT https://community.qlik.com/t5/QlikView/Average-on-Set-Analysis/m-p/938771#M323943 swuehl 2015-11-19T14:26:16Z