topic Re: Exclusion criteria in set analysis in QlikView

Exclusion criteria in set analysis

infock12 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Exclusion criteria in set analysis

sunny_talwar — Fri, 15 Apr 2016 15:36:32 GMT

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

Re: Exclusion criteria in set analysis

Gysbert_Wassenaar — Fri, 15 Apr 2016 15:37:26 GMT

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

Re: Exclusion criteria in set analysis

swuehl — Fri, 15 Apr 2016 15:37:57 GMT

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.

Re: Exclusion criteria in set analysis

infock12 — Fri, 15 Apr 2016 15:38:39 GMT

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

Re: Exclusion criteria in set analysis

infock12 — Fri, 15 Apr 2016 15:40:30 GMT

Hi swuehl,

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