topic Re: How to use an OR clause in a CountIf statement? in QlikView

How to use an OR clause in a CountIf statement?

kfahri342 — Sat, 16 Nov 2024 00:50:02 GMT

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

Re: How to use an OR clause in a CountIf statement?

rubenmarin — Thu, 16 Apr 2020 11:23:16 GMT

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

Re: How to use an OR clause in a CountIf statement?

Brett_Bleess — Thu, 14 May 2020 14:47:32 GMT

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/SetAnalysis/set-analysis-expressions.htm

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