How to use an OR clause in a CountIf statement?

[kfahri342]

Hi, I have the following data table sample:

System	A	B	C
1	Y	N	N
2	N	Y	Y
3	N	N	Y
4	N	N	N

In one of my dashboards, I want a view to show Systems that are equal to A = Y or  B = Y or C = Y. So in this example only System 1, 2 and 3 are should show.

Currently I have tried 

=Count({< A = {'Y'} or B = {'Y'} or C = {'Y'}>} System)

But i just get an error in expression. 

Thanks

[rubenmarin · Accepted solution]

Hi, the syntax can be: =Count({<A={'Y'}>+<B={'Y'}>+<C={'Y'}>} System)

So, differnet sets identified between <>, with + to make an OR between this sets

[Brett_Bleess]

Just posting Help link on things as there is further documentation there on what Ruben mentioned:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

The following Design Blog may be helpful too:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

I am going to mark Ruben's post as the solution given you have not replied back, so I am assuming that worked.

Regards,
Brett