Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
Not applicable

Highest

Hi,

1 Solution

Accepted Solutions
Not applicable

Highest Value

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

1 Reply
Not applicable

Highest Value

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

Community Browser