Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Beginer
Contributor
Contributor
‎2023-03-13 12:17 AM

calculating per customer Max, No

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

 

Error in expression

Labels (1)
Labels
443 Views
0 Likes
1 Reply
vikasmahajan
MVP
MVP
‎2023-03-14 03:00 AM

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.
408 Views