topic Expression review in QlikView https://community.qlik.com/t5/QlikView/Expression-review/m-p/473955#M1137091 <HTML><HEAD></HEAD><BODY><P style="text-align: left;"><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">1. SCAR </SPAN><SPAN style="color: #0033cc; font-size: 10pt; font-style: italic; text-decoration: underline; font-family: Arial; font-weight: bold;">open</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> in particular month (MTH):</SPAN></P><P style="text-align: left;"><SPAN style="font-size: 10pt;">-</SPAN>&nbsp; <SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InitiationDate</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &lt;= MTH&nbsp; AND</SPAN></P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"><SPAN style="font-size: 10pt;">-</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">&nbsp; [ </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestDue</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &lt;&gt; NULL&nbsp; AND&nbsp;&nbsp; ( </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestComplete</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">&nbsp; = NULL&nbsp; OR&nbsp; </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestComplete</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &gt;= MTH )&nbsp; OR</SPAN></P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"><SPAN style="font-size: 10pt;">-</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">&nbsp; ( same for </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">ImplementationDate</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> ) ]</SPAN></P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"> </P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">to know the timelines as intime....</SPAN></P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"> </P><P style="text-align: left;"><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">2. SCAR </SPAN><SPAN style="color: #0033cc; font-size: 10pt; font-style: italic; text-decoration: underline; font-family: Arial; font-weight: bold;">late</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> in particular month (MTH):</SPAN></P><P style="text-align: left;"><SPAN style="font-size: 10pt;">-</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">&nbsp; SCAR open (see above)&nbsp; AND</SPAN></P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"><SPAN style="font-size: 10pt;">-</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> [ </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestDue</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &lt;&gt; NULL&nbsp; AND&nbsp;&nbsp; </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestDue</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &lt;= MTH&nbsp; AND&nbsp; ( </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestComplete</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &gt; </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestDue</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">&nbsp; OR&nbsp; Today() &gt; </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestDue</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> )&nbsp; OR</SPAN></P><P><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> ( same for </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">ImplementationDate</SPAN></P><P> </P><P><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">to know the timeliness as past due...</SPAN></P><P> </P><P><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">Need the expression for this scenario..</SPAN></P></BODY></HTML> Sun, 03 Nov 2013 21:34:12 GMT 2013-11-03T21:34:12Z Expression review https://community.qlik.com/t5/QlikView/Expression-review/m-p/473955#M1137091 <HTML><HEAD></HEAD><BODY><P style="text-align: left;"><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">1. SCAR </SPAN><SPAN style="color: #0033cc; font-size: 10pt; font-style: italic; text-decoration: underline; font-family: Arial; font-weight: bold;">open</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> in particular month (MTH):</SPAN></P><P style="text-align: left;"><SPAN style="font-size: 10pt;">-</SPAN>&nbsp; <SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InitiationDate</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &lt;= MTH&nbsp; AND</SPAN></P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"><SPAN style="font-size: 10pt;">-</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">&nbsp; [ </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestDue</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &lt;&gt; NULL&nbsp; AND&nbsp;&nbsp; ( </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestComplete</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">&nbsp; = NULL&nbsp; OR&nbsp; </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestComplete</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &gt;= MTH )&nbsp; OR</SPAN></P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"><SPAN style="font-size: 10pt;">-</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">&nbsp; ( same for </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">ImplementationDate</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> ) ]</SPAN></P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"> </P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">to know the timelines as intime....</SPAN></P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"> </P><P style="text-align: left;"><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">2. SCAR </SPAN><SPAN style="color: #0033cc; font-size: 10pt; font-style: italic; text-decoration: underline; font-family: Arial; font-weight: bold;">late</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> in particular month (MTH):</SPAN></P><P style="text-align: left;"><SPAN style="font-size: 10pt;">-</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">&nbsp; SCAR open (see above)&nbsp; AND</SPAN></P><P class="O1" style="text-align: left; text-indent: -0.31in; margin-left: 0.5in;"><SPAN style="font-size: 10pt;">-</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> [ </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestDue</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &lt;&gt; NULL&nbsp; AND&nbsp;&nbsp; </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestDue</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &lt;= MTH&nbsp; AND&nbsp; ( </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestComplete</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> &gt; </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestDue</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">&nbsp; OR&nbsp; Today() &gt; </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">InvestDue</SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> )&nbsp; OR</SPAN></P><P><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;"> ( same for </SPAN><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">ImplementationDate</SPAN></P><P> </P><P><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">to know the timeliness as past due...</SPAN></P><P> </P><P><SPAN style="font-style: italic; font-family: Arial; color: #0033cc; font-size: 10pt; font-weight: bold;">Need the expression for this scenario..</SPAN></P></BODY></HTML> Sun, 03 Nov 2013 21:34:12 GMT https://community.qlik.com/t5/QlikView/Expression-review/m-p/473955#M1137091 2013-11-03T21:34:12Z