https://community.qlik.com/t5/QlikView/Nested-Aggregation-not-allowed/m-p/1518938#M749040 <P>Is this what you want?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/1936i3094EA02770D0506/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span>If this is what you want, try this</P><PRE>='Max Date:' &amp; Date(Max(OrderDate))</PRE><P>&nbsp;</P> Tue, 11 Dec 2018 01:39:31 GMT sunny_talwar 2018-12-11T01:39:31Z https://community.qlik.com/t5/QlikView/Nested-Aggregation-not-allowed/m-p/1518921#M749038 <P>Hi,</P><P>I am trying to add a Text to my chart to show a max value of a field.</P><P>But getting an error Nested Aggregation not allowed. Is there a way to fix it.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Nested_Agg.PNG" style="width: 759px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/1933i5C1D91B0BDFED2C8/image-size/large?v=v2&amp;px=999" role="button" title="Nested_Agg.PNG" alt="Nested_Agg.PNG" /></span></P><P>&nbsp;</P> Sat, 16 Nov 2024 05:00:15 GMT https://community.qlik.com/t5/QlikView/Nested-Aggregation-not-allowed/m-p/1518921#M749038 sqlpuzzle 2024-11-16T05:00:15Z https://community.qlik.com/t5/QlikView/Nested-Aggregation-not-allowed/m-p/1518927#M749039 <P>You'll need to use an aggr() function when you have a nested aggregation.&nbsp; See&nbsp;<A href="https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctions/aggr.htm" target="_blank">https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctions/aggr.htm</A></P><P>&nbsp;</P><P>Post your expression here if you want a suggestion.</P><P>&nbsp;</P><P>-Rob</P> Mon, 10 Dec 2018 23:18:01 GMT https://community.qlik.com/t5/QlikView/Nested-Aggregation-not-allowed/m-p/1518927#M749039 rwunderlich 2018-12-10T23:18:01Z https://community.qlik.com/t5/QlikView/Nested-Aggregation-not-allowed/m-p/1518938#M749040 <P>Is this what you want?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/1936i3094EA02770D0506/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span>If this is what you want, try this</P><PRE>='Max Date:' &amp; Date(Max(OrderDate))</PRE><P>&nbsp;</P> Tue, 11 Dec 2018 01:39:31 GMT https://community.qlik.com/t5/QlikView/Nested-Aggregation-not-allowed/m-p/1518938#M749040 sunny_talwar 2018-12-11T01:39:31Z