Query with set analysis expression

[hopkinsc]

Hi all,

I am trying to get some sety analysis to work but struggling..

I want to set some slice colours in a pie chart.

Currently i have the following in the background colour of the expression

=if(LineFlag = 'R',rgb(255,0,0),

if(LineFlag = 'G', rgb(0,255,0),

if(LineFlag = 'A', rgb(255,153,18), rgb(255,0,0))))

But i want to set each pie chart to a specific week.

The expression i am using is

=COUNT({$<WeekDesc = {'6'}>} PordDetail)

How c=would i include the set analysis in this expression into the background colour expression.?

Thanks

[swuehl · Accepted solution]

Try using only() around Lineflag:

=if( only({$<WeekDesc = {6}>}LineFlag) = 'R',rgb(255,0,0),...

[hopkinsc]

Thanks Stefan