topic Re: and/or condition in QlikView

and/or condition

karolina_ — Wed, 25 Jul 2018 09:52:19 GMT

Hi Guys,

1. How does and works in qlikview?

If we have contidion:
if(A = 1 and B =2 and C=2,'YES','NO')

Would QV skip checking B and C if A<>1 or would all A,B,C be checked?

2. How does or works in qlikview?

If we have contidion:
if(A = 1 or B =2 or C=2,'YES','NO')

Would QV skip checking B and C if A=1 or would all A,B,C be checked?

Re: and/or condition

sunny_talwar — Wed, 25 Jul 2018 11:53:07 GMT

I think in neither of the cases, QV will stop checking at a failure of part of the condition.... This link might not be directly related... but read HIC's response here

Re: help - performance improvements

Re: and/or condition

BalaBhaskar_Qlik — Wed, 25 Jul 2018 13:03:08 GMT

1). AND - All A,B,C values should pass the filter, if not it'll fail.

2). OR - In A,B,C values, any of the value pass the filter.