Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
jgreen95
Contributor III
Contributor III

Show value of Max dimension

I have used the solution  here  to use the First Sorted Value function to show the dimension with the highest value.

How would I show the value for said dimension?

I know it could be done with an IF statement but i have over 200 dimensions so this would be ridiculous.

 

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

Use this

Max(Aggr(Sum([Sales]), [Country]))

View solution in original post

1 Reply
sunny_talwar

Use this

Max(Aggr(Sum([Sales]), [Country]))