Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
freceena
Contributor II
Contributor II

Maximum inside sum function

I am getting error while using the following expression: 

sum(max([Counter])-max(Before_mil))

Could anyone please help on this.

Labels (2)
3 Replies
dilipranjith
Partner
Partner

nested aggregation is not allowed.

why not just max([Counter])-max(Before_mil)?

explain scenario more

MayilVahanan

HI @freceena 

sum(Aggr(max([Counter])-max(Before_mil),Dimension))

Nested aggregation is possible in Aggr function.

Thanks & Regards,
Mayil Vahanan R
Brett_Bleess
Support (Former)
Support (Former)

@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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.