topic Re: Fields within Set Analysis in App Development https://community.qlik.com/t5/App-Development/Fields-within-Set-Analysis/m-p/1441526#M34884 <HTML><HEAD></HEAD><BODY><P>not so sure but</P><P></P><P>Avg({&lt;FFMessage={'Score - Sales investigation'}, Survey_date = p(SendDate)&gt;}[Given Score])</P></BODY></HTML> Wed, 22 Nov 2017 12:08:09 GMT shraddha_g 2017-11-22T12:08:09Z Fields within Set Analysis https://community.qlik.com/t5/App-Development/Fields-within-Set-Analysis/m-p/1441524#M34882 <HTML><HEAD></HEAD><BODY><P>I am calculation the average score but also have a check that the Survey_date and SendDate are the same. I know the first part of the set analysis but it is the Survey_date part which is causing the error. Both Survey_date and SendDate are both fields.</P><P></P><P>Avg({&lt;FFMessage={'Score - Sales investigation'}, Survey_date={"=$(=SendDate)"}&gt;}[Given Score])</P></BODY></HTML> Wed, 22 Nov 2017 12:04:51 GMT https://community.qlik.com/t5/App-Development/Fields-within-Set-Analysis/m-p/1441524#M34882 Anonymous 2017-11-22T12:04:51Z Re: Fields within Set Analysis https://community.qlik.com/t5/App-Development/Fields-within-Set-Analysis/m-p/1441525#M34883 <HTML><HEAD></HEAD><BODY><P>avg({&lt;FFMessage={'Score - Sales investigation'}&gt;}if(Survey_date=SendDate,GivenScore))</P><P></P><P>or </P><P>avg({&lt;FFMessage={'Score - Sales investigation'},Key_Column={"=Survey_date=SendDate"}&gt;}GivenScore)</P></BODY></HTML> Wed, 22 Nov 2017 12:08:01 GMT https://community.qlik.com/t5/App-Development/Fields-within-Set-Analysis/m-p/1441525#M34883 ali_hijazi 2017-11-22T12:08:01Z Re: Fields within Set Analysis https://community.qlik.com/t5/App-Development/Fields-within-Set-Analysis/m-p/1441526#M34884 <HTML><HEAD></HEAD><BODY><P>not so sure but</P><P></P><P>Avg({&lt;FFMessage={'Score - Sales investigation'}, Survey_date = p(SendDate)&gt;}[Given Score])</P></BODY></HTML> Wed, 22 Nov 2017 12:08:09 GMT https://community.qlik.com/t5/App-Development/Fields-within-Set-Analysis/m-p/1441526#M34884 shraddha_g 2017-11-22T12:08:09Z