Qlik Community

App Development

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
luismadriz
Specialist
Specialist

Finding Max

Hi there,

Brain freeze here! How do I find and mark the Max for each Dim1? How do I reduce the scope?

=if(Sum(Measure)=Max(Aggr(Sum(Measure),Dim1,Dim2)),'Max')

Untitled.png

1 Solution

Accepted Solutions
sunny_talwar

‌This

=if(Sum(Measure)=Max(TOTAL <Dim1>Aggr(Sum(Measure),Dim1,Dim2)),'Max')

View solution in original post

2 Replies
sunny_talwar

‌This

=if(Sum(Measure)=Max(TOTAL <Dim1>Aggr(Sum(Measure),Dim1,Dim2)),'Max')

View solution in original post

luismadriz
Specialist
Specialist
Author

Thanks Sunny

Untitled.png