topic Re: Struggling with an expression in QlikView https://community.qlik.com/t5/QlikView/Struggling-with-an-expression/m-p/987252#M644643 <HTML><HEAD></HEAD><BODY><P>Are you using it within a table, or just as a text object?</P><P></P><P>If just a text object, try:</P><P></P><P><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Count</SPAN>(<SPAN style="color: #0000ff;">If</SPAN>(<SPAN style="color: #0000ff;">Aggr</SPAN>(<SPAN style="color: #0000ff;">Avg</SPAN>({&lt;<SPAN style="color: #800000;">[Skill]</SPAN> = {'1'}, <SPAN style="color: #800000;">[Role]</SPAN> = {'R'}, <SPAN style="color: #800000;">[Act]</SPAN> = {'Y'}&gt;} <SPAN style="color: #800000;">Score</SPAN>), <SPAN style="color: #800000;">Name</SPAN>) &gt; 3.5, <SPAN style="color: #800000;">Name</SPAN>)) </SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN><BR />Assuming what you are trying to do is count all the names who have scored over an average of 3.5 for any entry in which Skill, Role and Act are defined as above.</P><P></P><P>If not, explain what you're trying to calculate.</P></BODY></HTML> Thu, 26 Nov 2015 10:07:44 GMT morganaaron 2015-11-26T10:07:44Z Struggling with an expression https://community.qlik.com/t5/QlikView/Struggling-with-an-expression/m-p/987251#M644642 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am struggling with an expression.The below keeps returning an error:</P><P></P><P>=count({&lt;[Skill] = {'1'}, [Role] = {'R'}, [Act] = {'Y'}&gt;} if(avg([score]&gt;3.5, [Name])</P><P></P><P>Can anyone tell me what I am doing wrong?</P></BODY></HTML> Thu, 26 Nov 2015 08:51:46 GMT https://community.qlik.com/t5/QlikView/Struggling-with-an-expression/m-p/987251#M644642 2015-11-26T08:51:46Z Re: Struggling with an expression https://community.qlik.com/t5/QlikView/Struggling-with-an-expression/m-p/987252#M644643 <HTML><HEAD></HEAD><BODY><P>Are you using it within a table, or just as a text object?</P><P></P><P>If just a text object, try:</P><P></P><P><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Count</SPAN>(<SPAN style="color: #0000ff;">If</SPAN>(<SPAN style="color: #0000ff;">Aggr</SPAN>(<SPAN style="color: #0000ff;">Avg</SPAN>({&lt;<SPAN style="color: #800000;">[Skill]</SPAN> = {'1'}, <SPAN style="color: #800000;">[Role]</SPAN> = {'R'}, <SPAN style="color: #800000;">[Act]</SPAN> = {'Y'}&gt;} <SPAN style="color: #800000;">Score</SPAN>), <SPAN style="color: #800000;">Name</SPAN>) &gt; 3.5, <SPAN style="color: #800000;">Name</SPAN>)) </SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN><BR />Assuming what you are trying to do is count all the names who have scored over an average of 3.5 for any entry in which Skill, Role and Act are defined as above.</P><P></P><P>If not, explain what you're trying to calculate.</P></BODY></HTML> Thu, 26 Nov 2015 10:07:44 GMT https://community.qlik.com/t5/QlikView/Struggling-with-an-expression/m-p/987252#M644643 morganaaron 2015-11-26T10:07:44Z