Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am getting error while using the following expression:
sum(max([Counter])-max(Before_mil))
Could anyone please help on this.
nested aggregation is not allowed.
why not just max([Counter])-max(Before_mil)?
explain scenario more
HI @freceena
sum(Aggr(max([Counter])-max(Before_mil),Dimension))
Nested aggregation is possible in Aggr function.
@freceena Just tossing in the following Design Blog link on Pitfalls of AGGR that has some additional links, but that may further clarify the other two posts more for you. If one of the posts did resolve your use case, please be sure to return to the thread and use the Accept as Solution button on the post(s) that helped to mark the solution and close out the thread, it is much appreciated. If you have further questions, please leave an update.
https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275
Regards,
Brett