set analysis in concat/aggr function?

[Anonymous]

Hi!

I'm trying to display the Team name that a person belongs to. Problem is that the person can belong to several teams in the past. What i want to see is only the team that the person blongs to today.

This is the one i'm currently using

concat(distinct aggr(if(sum(Points)>0,Team),Name,Team),',')

(Points must be moore than 0 by the way, hence the expression. )

But that gives me all the teams the person belongs to. how do i do this to include the Date issue?

//A.

[perumal_41]

Upload ur Qvw file

[erichshiino]

I'm not sure about the criteria to show only one,

but you can use set analysis with maxstring as well...

=maxstring( {<TEAM = {"=SUM(POINTS)>0"}>} TEAM)

EDIT : Correction in the expression

[Anonymous]

This one is close but the problem here is that maxstring collects the last team and the teams are in an alfabetical order so it shows the wrong value when it comes to terms of last team-membership date-wise.