Query with set analysis expression

hopkinsc — Wed, 01 Aug 2012 15:53:34 GMT

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

Re: Query with set analysis expression

swuehl — Wed, 01 Aug 2012 16:00:14 GMT

Try using only() around Lineflag:

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

hopkinsc — Wed, 01 Aug 2012 16:26:54 GMT

Thanks Stefan