topic Re: Load with where clause AND OR AND in QlikView

Load with where clause AND OR AND

Fri, 28 Aug 2015 13:03:15 GMT

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

From file.xlsx

Where A=xxx AND B=xxx

Where C=xxx AND D=xxx

Many thanks!

Neal

Re: Load with where clause AND OR AND

Gysbert_Wassenaar — Fri, 28 Aug 2015 16:56:50 GMT

Load

From file.xlsx

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

Re: Load with where clause AND OR AND

qlikviewwizard — Sat, 29 Aug 2015 07:14:12 GMT

Hi Try Gysbert advise.

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

Re: Load with where clause AND OR AND

MarcoWedel — Sat, 29 Aug 2015 11:26:55 GMT

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

should also work.

regards

Marco

Re: Load with where clause AND OR AND

jagan — Sat, 29 Aug 2015 12:43:07 GMT

Hi,

Try like this

Data:

Load

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

MarcoWedel — Sat, 29 Aug 2015 14:33:29 GMT

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

Re: Load with where clause AND OR AND

qlikviewwizard — Sun, 30 Aug 2015 12:55:43 GMT

Hi,

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

Re: Load with where clause AND OR AND

Anonymous — Sun, 30 Aug 2015 13:29:04 GMT

Good Explaination