Load with where clause AND OR AND

[#1]

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

[Gysbert_Wassenaar]

Load

A

B

C

D

From file.xlsx

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

[qlikviewwizard]

Hi Try Gysbert advise.

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

[MarcoWedel]

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

should also work.

regards

Marco

[jagan]

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.

[MarcoWedel]

Hi,

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

hope this helps

regards

Marco

[qlikviewwizard]

Hi,

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

[Anonymous]

Good Explaination