Expression in concat-function

[Anonymous]

Hi guys,

I have a chart (straight table) where Name is the dimension and in my expression i want to see the Team they belong to.

I have the following expression;

concat({$<Team={"=sum(Points)>0"}>} distinct Team, ', ')

The Name (person) can have different Teams over time so in my appliaction i've chosen 2011 and april, but. My selection does not seem to affect the expression.

One person (Name) has two Teams in the chart but i know for a fact that there was no points for one of the Teams he once belonged to.

Help please..

//Annika.

[swuehl]

Hi Annika,

could you post an example .qvw-file? It's much easier to help you then.

(You can upload it in advanced editor)

Regards,

Stefan

[johnw · Accepted solution]

Set analysis ignores your dimension values.  So when it's checking for teams with points, it's checking for teams with points from anyone, not just for the person named on the row.  (Edit: Well, the person still needs to be on the team, but they don't have to have points on the team as long as someone else has points on the team.)  So you'll probably need to do this another way.  Perhaps like this?

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

[Anonymous]

It worked great!

Thanks a lot John!

//A.

[Anonymous]

I have a problem again that's relatied to this.

In my application i only want to show the Team that's relevant today. So if a person belonged to Team 1 yesterday and Team 2 today i onyl want to show Team 2.

Is this possible?