calculating per customer Max, No - Qlik Community

Beginer · ‎2023-03-13

Aggr(nodistinct Max(UnitPrice * UnitSales), Customer) = (UnitPrice * UnitSales), 'Max' , 'No'

Error in expression

vikasmahajan · ‎2023-03-14

Hi ,

Can you try this

Max ( aggr ( sum ( UnitPrice * UnitSales ), Customer) )

https://www.analyticsvidhya.com/blog/2014/02/aggr/

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.