Skip to main content

Qlik

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
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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: 
Not applicable
‎2012-04-30 07:53 AM

Highest

Hi,

377 Views
0 Likes
1 Solution

Accepted Solutions
Not applicable
‎2012-04-30 08:41 AM
Author

Hi,

I have one sulution that is working, don't think it is the best one though:

Dimension 1 --> Team

Dimension 2 --> =SUBFIELD(AGGR(MINSTRING(1/Score & '|' & Name), Team), '|', 2)

Expression --> MAX(Score)

Don't know what happens if several persons in same team have same score.

Cheers

View solution in original post

195 Views
0 Likes
1 Reply
Not applicable
‎2012-04-30 08:41 AM
Author

Hi,

I have one sulution that is working, don't think it is the best one though:

Dimension 1 --> Team

Dimension 2 --> =SUBFIELD(AGGR(MINSTRING(1/Score & '|' & Name), Team), '|', 2)

Expression --> MAX(Score)

Don't know what happens if several persons in same team have same score.

Cheers

196 Views
0 Likes