Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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
qlikviewwizard
Master II
Master II

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
Luminary Alumni
Luminary Alumni

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:

QlikCommunity_Thread_178322_Pic1.png

hope this helps

regards

Marco

qlikviewwizard
Master II
Master II

Hi,

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

Anonymous
Not applicable
Author

Good Explaination