topic Re: Straight Table : Nested Aggregation Not Allowed in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-Nested-Aggregation-Not-Allowed/m-p/998420#M339512 <HTML><HEAD></HEAD><BODY><P>The way QV reports syntax errors has changed in latest SR (i.e. it may now stop showing content and displays an error message). Have a look into Rob Wunderlich's latest blog entry.</P><P></P><P>I can't see anything wrong with your expression, though. Maybe you are looking not at the right expression, the issue can also be caused by e.g. Color Attribute expressions etc.</P></BODY></HTML> Wed, 26 Aug 2015 11:06:35 GMT swuehl 2015-08-26T11:06:35Z Straight Table : Nested Aggregation Not Allowed https://community.qlik.com/t5/QlikView/Straight-Table-Nested-Aggregation-Not-Allowed/m-p/998419#M339511 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>In the process of testing QV11 SR12 (currently on SR4).</P><P><IMG alt="For Forum.png" class="jive-image image-1" src="/legacyfs/online/97013_For Forum.png" style="width: 620px; height: 224px;" /></P><P></P><P>The straight table worked okay in SR4 but I am receiving the following error in SR12.</P><P>Am using straight table as opposed to Pivot as I want the data displayed as a butterfly table.</P><P></P><P>Error in expression: Nested aggregation not allowed.</P><P></P><P>An example of the formula used is...</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">ind_Period</SPAN><SPAN style="font-size: 8pt;"> = {'Current'}&gt; } </SPAN><SPAN style="color: #800000; font-size: 8pt;">ind_OnHandValue</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="font-size: 10pt;">Any ideas?</SPAN><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Many Thanks</SPAN></P><P><SPAN style="font-size: 10pt;">Paul<BR /></SPAN></P></BODY></HTML> Wed, 26 Aug 2015 10:28:38 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Nested-Aggregation-Not-Allowed/m-p/998419#M339511 pkelly 2015-08-26T10:28:38Z Re: Straight Table : Nested Aggregation Not Allowed https://community.qlik.com/t5/QlikView/Straight-Table-Nested-Aggregation-Not-Allowed/m-p/998420#M339512 <HTML><HEAD></HEAD><BODY><P>The way QV reports syntax errors has changed in latest SR (i.e. it may now stop showing content and displays an error message). Have a look into Rob Wunderlich's latest blog entry.</P><P></P><P>I can't see anything wrong with your expression, though. Maybe you are looking not at the right expression, the issue can also be caused by e.g. Color Attribute expressions etc.</P></BODY></HTML> Wed, 26 Aug 2015 11:06:35 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Nested-Aggregation-Not-Allowed/m-p/998420#M339512 swuehl 2015-08-26T11:06:35Z Re: Straight Table : Nested Aggregation Not Allowed https://community.qlik.com/t5/QlikView/Straight-Table-Nested-Aggregation-Not-Allowed/m-p/998421#M339513 <HTML><HEAD></HEAD><BODY><P>Thanks, Rob's blog explained how to change the "Silent Error in Chart" option to 1.</P></BODY></HTML> Wed, 26 Aug 2015 15:43:26 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Nested-Aggregation-Not-Allowed/m-p/998421#M339513 pkelly 2015-08-26T15:43:26Z