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?
Where A=xxx AND B=xxx
Where C=xxx AND D=xxx
Where (A=xxx AND B=xxx) OR (C=xxx AND D=xxx) ;
Hi Try Gysbert advise.
We can achieve with WildMatch function as well. Thank you.
Where A=xxx AND B=xxx OR C=xxx AND D=xxx;
should also work.
Try like this
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'
as the boolean and-operator usually has a higher priority than the or-operator, it should indeed be the same:
hope this helps
Please close the thread if u able to manage. Thank you.
Retrieving data ...