topic Error in Calculated Expression error when using Count and Only Functions in QlikView https://community.qlik.com/t5/QlikView/Error-in-Calculated-Expression-error-when-using-Count-and-Only/m-p/250561#M497461 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am new&nbsp; to QlikView&nbsp; and having an issue with trying to get a chart to work. I added an expression in the expression tab to represent the denominator of the calculation:</P><P></P><P>Count(Only(MyField='Foo''))</P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P></P><P>However I get an error in calculated expression message. Am I allowed to embed a one function inside another when creating an expression? Basically I am using this as a SQL where claus e as I need multiple charts based on values found in 'MyField'. Any help would be greatly appreciated! Thanks.....</P></BODY></HTML> Fri, 14 Oct 2011 14:23:05 GMT 2011-10-14T14:23:05Z Error in Calculated Expression error when using Count and Only Functions https://community.qlik.com/t5/QlikView/Error-in-Calculated-Expression-error-when-using-Count-and-Only/m-p/250561#M497461 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am new&nbsp; to QlikView&nbsp; and having an issue with trying to get a chart to work. I added an expression in the expression tab to represent the denominator of the calculation:</P><P></P><P>Count(Only(MyField='Foo''))</P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P></P><P>However I get an error in calculated expression message. Am I allowed to embed a one function inside another when creating an expression? Basically I am using this as a SQL where claus e as I need multiple charts based on values found in 'MyField'. Any help would be greatly appreciated! Thanks.....</P></BODY></HTML> Fri, 14 Oct 2011 14:23:05 GMT https://community.qlik.com/t5/QlikView/Error-in-Calculated-Expression-error-when-using-Count-and-Only/m-p/250561#M497461 2011-10-14T14:23:05Z Re: Error in Calculated Expression error when using Count and Only Functions https://community.qlik.com/t5/QlikView/Error-in-Calculated-Expression-error-when-using-Count-and-Only/m-p/250562#M497462 <HTML><HEAD></HEAD><BODY><P>You can't just embed one aggregation function (and only() is also an aggregation function) within another like count().</P><P>(You could use aggr() function to get around this)</P><P></P><P>Or try maybe</P><P>= sum( if(MyField = 'Foo',1,0))</P><P></P><P></P><P>Stefan</P></BODY></HTML> Fri, 14 Oct 2011 14:32:44 GMT https://community.qlik.com/t5/QlikView/Error-in-Calculated-Expression-error-when-using-Count-and-Only/m-p/250562#M497462 swuehl 2011-10-14T14:32:44Z