Combination of AND and OR function in Set Analysis.

[#1]

I have a sql query as given below :-

Sum(Amount) from table where A=1 AND B=1 AND C=1 AND(X=NA OR Y=NA OR Z=NA)

How can I write this sql query in my SET Analysis expression?

[#2]

Hi Anees,

I would suggest creating a flag in your script and then using this in your set analysis.

Load *,

If(A=1 AND B=1 AND C=1 AND(X='NA' OR Y='NA' OR Z='NA'),1) as %Flag

from....

Sum({<%Flag={1}>} Amount)

Hope that helps

Joe

[Digvijay_Singh]

Se if this can be used, will be simpler if can be used in your situaiton-

=Sum(if(A=1 and B=1 and C=1 and (X='NA' or Y='NA' or Z='NA'),Amount))

[maxgro · Accepted solution]

try

sum({$ <A={1},B={1},C={1}>*(<X={NA}>+<Y={NA}>+<Z={NA}>)}  Amount)

[#5]

Thanks a bunch max 🙂

Now it is working as per our requirement.