topic Re: Combination of AND and OR function in Set Analysis. in QlikView https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/956000#M968502 <HTML><HEAD></HEAD><BODY><P>Hi Anees,</P><P></P><P>I would suggest creating a flag in your script and then using this in your set analysis.</P><P></P><P>Load *,</P><P>If(A=1 AND B=1 AND C=1 AND(X='NA' OR Y='NA' OR Z='NA'),1) as %Flag</P><P>from....</P><P></P><P>Sum({&lt;%Flag={1}&gt;} Amount)</P><P></P><P>Hope that helps</P><P>Joe</P></BODY></HTML> Tue, 29 Sep 2015 15:57:04 GMT 2015-09-29T15:57:04Z Combination of AND and OR function in Set Analysis. https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/955999#M968501 <HTML><HEAD></HEAD><BODY><P>I have a sql query as given below :- </P><P><STRONG>Sum(Amount)</STRONG> from <STRONG>table</STRONG> where <STRONG>A=1 AND B=1 AND C=1 AND(X=NA OR Y=NA OR Z=NA)</STRONG></P><P></P><P>How can I write this sql query in my SET Analysis expression?</P></BODY></HTML> Tue, 29 Sep 2015 07:27:19 GMT https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/955999#M968501 2015-09-29T07:27:19Z Re: Combination of AND and OR function in Set Analysis. https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/956000#M968502 <HTML><HEAD></HEAD><BODY><P>Hi Anees,</P><P></P><P>I would suggest creating a flag in your script and then using this in your set analysis.</P><P></P><P>Load *,</P><P>If(A=1 AND B=1 AND C=1 AND(X='NA' OR Y='NA' OR Z='NA'),1) as %Flag</P><P>from....</P><P></P><P>Sum({&lt;%Flag={1}&gt;} Amount)</P><P></P><P>Hope that helps</P><P>Joe</P></BODY></HTML> Tue, 29 Sep 2015 15:57:04 GMT https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/956000#M968502 2015-09-29T15:57:04Z Re: Combination of AND and OR function in Set Analysis. https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/956001#M968503 <HTML><HEAD></HEAD><BODY><P>Se if this can be used, will be simpler if can be used in your situaiton- </P><P></P><P>=Sum(if(A=1 and B=1 and C=1 and (X='NA' or Y='NA' or Z='NA'),Amount))</P></BODY></HTML> Tue, 29 Sep 2015 16:39:31 GMT https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/956001#M968503 Digvijay_Singh 2015-09-29T16:39:31Z Re: Combination of AND and OR function in Set Analysis. https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/956002#M968504 <HTML><HEAD></HEAD><BODY><P>try</P><P></P><P>sum({$ &lt;A={1},B={1},C={1}&gt;*(&lt;X={NA}&gt;+&lt;Y={NA}&gt;+&lt;Z={NA}&gt;)}&nbsp; Amount)</P></BODY></HTML> Tue, 29 Sep 2015 16:52:49 GMT https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/956002#M968504 maxgro 2015-09-29T16:52:49Z Re: Combination of AND and OR function in Set Analysis. https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/956003#M968505 <HTML><HEAD></HEAD><BODY><P>Thanks a bunch max <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>Now it is working as per our requirement.</P></BODY></HTML> Wed, 30 Sep 2015 05:10:50 GMT https://community.qlik.com/t5/QlikView/Combination-of-AND-and-OR-function-in-Set-Analysis/m-p/956003#M968505 2015-09-30T05:10:50Z