topic Re: &gt;Today, AND, OR Condition in set analysis in QlikView https://community.qlik.com/t5/QlikView/gt-Today-AND-OR-Condition-in-set-analysis/m-p/988857#M337090 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌</P><P></P><P>Salute to you Boss....</P></BODY></HTML> Tue, 29 Dec 2015 07:57:12 GMT prma7799 2015-12-29T07:57:12Z >Today, AND, OR Condition in set analysis https://community.qlik.com/t5/QlikView/gt-Today-AND-OR-Condition-in-set-analysis/m-p/988854#M337087 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need a set analysis expression for a condition but unable to accomplish it.</P><P>count( if (Code is not null) and (EndDate is null or greater than today))</P><P></P><P>I would appreciate if anyone can help me on this.</P></BODY></HTML> Mon, 28 Dec 2015 12:18:35 GMT https://community.qlik.com/t5/QlikView/gt-Today-AND-OR-Condition-in-set-analysis/m-p/988854#M337087 malimohammed 2015-12-28T12:18:35Z Re: >Today, AND, OR Condition in set analysis https://community.qlik.com/t5/QlikView/gt-Today-AND-OR-Condition-in-set-analysis/m-p/988855#M337088 <HTML><HEAD></HEAD><BODY><P>May be something like this:</P><P></P><P><STRONG>Count({&lt;Code = {"=Len(Trim(Code)) &gt; 0"}, EndDate = {"=Len(Trim(EndDate)) = 0"}+{"$(='&gt;' &amp; Date(Today(), 'YourEndDateFormatHere'))"}&gt;} FieldYouAreCountingHere)</STRONG></P></BODY></HTML> Mon, 28 Dec 2015 15:14:18 GMT https://community.qlik.com/t5/QlikView/gt-Today-AND-OR-Condition-in-set-analysis/m-p/988855#M337088 sunny_talwar 2015-12-28T15:14:18Z Re: >Today, AND, OR Condition in set analysis https://community.qlik.com/t5/QlikView/gt-Today-AND-OR-Condition-in-set-analysis/m-p/988856#M337089 <HTML><HEAD></HEAD><BODY><P>Looks Perfect. Thanks a lot <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 29 Dec 2015 07:49:12 GMT https://community.qlik.com/t5/QlikView/gt-Today-AND-OR-Condition-in-set-analysis/m-p/988856#M337089 malimohammed 2015-12-29T07:49:12Z Re: >Today, AND, OR Condition in set analysis https://community.qlik.com/t5/QlikView/gt-Today-AND-OR-Condition-in-set-analysis/m-p/988857#M337090 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌</P><P></P><P>Salute to you Boss....</P></BODY></HTML> Tue, 29 Dec 2015 07:57:12 GMT https://community.qlik.com/t5/QlikView/gt-Today-AND-OR-Condition-in-set-analysis/m-p/988857#M337090 prma7799 2015-12-29T07:57:12Z