topic Re: Expression in concat-function in QlikView

Expression in concat-function

Anonymous — Fri, 01 Jul 2011 13:53:44 GMT

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.

Expression in concat-function

swuehl — Fri, 01 Jul 2011 13:58:14 GMT

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

Re: Expression in concat-function

johnw — Sat, 02 Jul 2011 00:08:18 GMT

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),',')

Expression in concat-function

Anonymous — Mon, 04 Jul 2011 08:03:43 GMT

It worked great!

Thanks a lot John!

//A.

Expression in concat-function

Anonymous — Tue, 13 Sep 2011 09:19:46 GMT

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?