Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load with where clause AND OR AND

Hi All,

I want to load data only if it fulfills requirement A and B OR C and D. Is it possible to do this in Qlikview?

Something like:

Load

A

B

C

D

From file.xlsx

Where A=xxx AND B=xxx

OR

Where C=xxx AND D=xxx

Many thanks!

Neal

7 Replies

Re: Load with where clause AND OR AND

Load

A

B

C

D

From file.xlsx

Where (A=xxx AND B=xxx) OR (C=xxx AND D=xxx) ;


talk is cheap, supply exceeds demand
Arjunarao
Honored Contributor II

Re: Load with where clause AND OR AND

Hi Try Gysbert advise.

We can achieve with WildMatch function as well. Thank you.

Re: Load with where clause AND OR AND

Where A=xxx AND B=xxx OR C=xxx AND D=xxx;

should also work.

regards

Marco

MVP
MVP

Re: Load with where clause AND OR AND

Hi,

Try like this

Data:

Load

A

B

C

D

From file.xlsx

Where (A='xxx' AND B='xxx') OR (C='xxx' AND D='xxx') ;

Note: (A='xxx' AND B='xxx') OR (C='xxx' AND D='xxx')  is different from A='xxx' AND B='xxx' OR C='xxx' AND D='xxx'

Regards,

Jagan.

Re: Load with where clause AND OR AND

Hi,

as the boolean and-operator usually has a higher priority than the or-operator, it should indeed be the same:

QlikCommunity_Thread_178322_Pic1.png

hope this helps

regards

Marco

Arjunarao
Honored Contributor II

Re: Load with where clause AND OR AND

Hi,

Please close the thread if u able to manage. Thank you.

rgvavihs
Valued Contributor

Re: Load with where clause AND OR AND

Good Explaination

Community Browser