topic whats wrong with this syntax? in QlikView https://community.qlik.com/t5/QlikView/whats-wrong-with-this-syntax/m-p/229064#M81031 <HTML><HEAD></HEAD><BODY><P>You cannot do nested agreegration unless using AGGR. Try playing with AGGR function. Otherwise you would need to adjust in your script and have new field, which could be a count of County groupped by Bird and the Food, based on what you are trying to do.</P></BODY></HTML> Sun, 01 Nov 2009 00:28:04 GMT disqr_rm 2009-11-01T00:28:04Z whats wrong with this syntax? https://community.qlik.com/t5/QlikView/whats-wrong-with-this-syntax/m-p/229063#M81030 <HTML><HEAD></HEAD><BODY><P>SUM(IF(<BR />Bird = 'Eagle' AND<BR />WILDMATCH(Food , '*All_*')<BR />,Value))</P><P>This Works...</P><P>Doenst Work</P><P>SUM(IF(<BR />Bird = 'Eagle' AND<BR />WILDMATCH(Food , '*All_*') AND</P><P>COUNT(TOTAL &lt;Kind&gt; Country) = 2<BR />,Value))</P><P>Last Exp gives a problem, What i'm i missing at the syntax?</P><P></P><P></P></BODY></HTML> Sat, 31 Oct 2009 20:54:46 GMT https://community.qlik.com/t5/QlikView/whats-wrong-with-this-syntax/m-p/229063#M81030 amien 2009-10-31T20:54:46Z whats wrong with this syntax? https://community.qlik.com/t5/QlikView/whats-wrong-with-this-syntax/m-p/229064#M81031 <HTML><HEAD></HEAD><BODY><P>You cannot do nested agreegration unless using AGGR. Try playing with AGGR function. Otherwise you would need to adjust in your script and have new field, which could be a count of County groupped by Bird and the Food, based on what you are trying to do.</P></BODY></HTML> Sun, 01 Nov 2009 00:28:04 GMT https://community.qlik.com/t5/QlikView/whats-wrong-with-this-syntax/m-p/229064#M81031 disqr_rm 2009-11-01T00:28:04Z