expression and excluding selection

Anonymous — Tue, 17 Jan 2012 10:19:31 GMT

Hi,

I have the following expression:

sum({$<Signt = , Team = , Name = >} Score)/

if(Team='Blue', avg({1} aggr(count({$<Created={'>0'}, Signt = , Team = , Name= >} distinct Signt), Date, Team))*0.78,

avg({1}aggr(count({$<Created={'>0'}, Signt = , Team = , Name= >} distinct Signt), Date, Team))

)

This expression shows the average score per day per Name/Signt over the chosen dates.

In my case where the problem occured, i've chosen one date.

But if a choose a Name that doesn't belong to the Blue team, the rule for the blue team doesn't apply.

How can i write this so that i can chose a Name/Signt but without having it effect the chart.

Thanks in advance!

topic expression and excluding selection in QlikView