Exclusion criteria in set analysis

[infock12]

Hi all,

I am trying to exclude a particular category in a bubble chart and a bar chart. I would like to exclude a few rows which has a category called 'Corp. Issue'. I tried things below but they didn't work. Please help!

The expression I am using is

=Count({<[Risk Category]-={'Corp. Issue'}>} [ID:]) - Here ID: is unique ID for all rows.

I am also using the Background Colour option under this expression to say,

=if(Avg({<[Risk Category]-={'Corp. Issue'}>}[Risk Rating - April 2016])>12, vRed,

if(Avg({<[Risk Category]-={'Corp. Issue'}>}[Risk Rating - April 2016])>=8, vAmber, vGreen))

Not sure if one of the above or both are wrong.

Thanks for your help in advance.

Regards,

Karthik

[sunny_talwar]

What about this:

=Count({<[ID:] = e({<[Risk Category] = {'Corp. Issue'}>})>} [ID:])

And not sure if you need to use any set analysis for the background color or not, but use the same set analysis

=If(Avg({<[ID:] = e({<[Risk Category] = {'Corp. Issue'}>})>} [Risk Rating - April 2016])>12, vRed,

If(Avg({<[ID:] = e({<[Risk Category] = {'Corp. Issue'}>})>} [Risk Rating - April 2016])>=8, vAmber, vGreen))

[Gysbert_Wassenaar]

Try =Count({1-<[Risk Category]={'Corp. Issue'}>} [ID:])

and

=if(Avg({1-<[Risk Category]={'Corp. Issue'}>}[Risk Rating - April 2016])>12, vRed,

if(Avg({1-<[Risk Category]={'Corp. Issue'}>}[Risk Rating - April 2016])>=8, vAmber, vGreen))

[swuehl]

Could you detail what the issue is, i.e. 'they didn't work'? No results, zero results, wrong values <> 0?

Set analysis is depending on your sets, so if possible, please upload a small sample QVW.

[infock12]

Wow, that is very quick. Both worked like a charm. Thanks Sunny and Gysbert for such a quick reply. Much appreciated!

[infock12]

Hi swuehl,

They worked but did not exclude the criteria I specified. Now it is sorted. Thank you very much though.