Solved: Highest - Qlik Community - 374123

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

Hi,

1 Solution

Accepted Solutions

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

1 Reply

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