Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
luismadriz
Valued Contributor

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

Re: Finding Max

‌This

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

2 Replies

Re: Finding Max

‌This

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

luismadriz
Valued Contributor

Re: Finding Max

Thanks Sunny

Untitled.png

Community Browser