Nested Aggregation not allowed

[sqlpuzzle]

Hi,

I am trying to add a Text to my chart to show a max value of a field.

But getting an error Nested Aggregation not allowed. Is there a way to fix it.

[rwunderlich]

You'll need to use an aggr() function when you have a nested aggregation.  See https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctio...

Post your expression here if you want a suggestion.

-Rob

[sunny_talwar · Accepted solution]

Is this what you want?

If this is what you want, try this

='Max Date:' & Date(Max(OrderDate))