topic Re: problem with expression script in QlikView https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758138#M661861 <HTML><HEAD></HEAD><BODY><P> if(<SPAN style="color: #000080;">#num</SPAN>(<SPAN style="color: #ff0000;">ENTRY_DATE</SPAN>)&lt;....</P><P></P><P>num<STRONG>#</STRONG> and NOT<STRONG>#</STRONG>num</P></BODY></HTML> Fri, 06 Feb 2015 10:04:56 GMT tresB 2015-02-06T10:04:56Z problem with expression script https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758137#M661860 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>can you help me with this expression?<BR />something is wrong?</P><P></P><P>= if(<SPAN style="color: #000080;">#num</SPAN>(<SPAN style="color: #ff0000;">ENTRY_DATE</SPAN>)&lt;<SPAN style="color: #000080;">num#</SPAN>(<SPAN style="color: #000080;">if</SPAN>(<SPAN style="color: #000080;">weekday</SPAN>(<SPAN style="color: #000080;">today</SPAN>())='Mo', <SPAN style="color: #000080;">date</SPAN>(<SPAN style="color: #000080;">today</SPAN>()-10), if(<SPAN style="color: #000080;">weekda</SPAN>y(<SPAN style="color: #000080;">today</SPAN>())='Sa', <SPAN style="color: #000080;">date</SPAN>(<SPAN style="color: #000080;">today</SPAN>()-9), date(<SPAN style="color: #000080;">today</SPAN>()-8)),</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #000080;">nullcount</SPAN>(<SPAN style="color: #ff0000;">MISSION_OPEN</SPAN>), 0 )</P></BODY></HTML> Fri, 06 Feb 2015 10:01:28 GMT https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758137#M661860 2015-02-06T10:01:28Z Re: problem with expression script https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758138#M661861 <HTML><HEAD></HEAD><BODY><P> if(<SPAN style="color: #000080;">#num</SPAN>(<SPAN style="color: #ff0000;">ENTRY_DATE</SPAN>)&lt;....</P><P></P><P>num<STRONG>#</STRONG> and NOT<STRONG>#</STRONG>num</P></BODY></HTML> Fri, 06 Feb 2015 10:04:56 GMT https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758138#M661861 tresB 2015-02-06T10:04:56Z Re: problem with expression script https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758139#M661862 <HTML><HEAD></HEAD><BODY><P>Furthermore one bracket ) is missing</P><P></P><P>= if(<SPAN style="color: #000080;">num#</SPAN>(<SPAN style="color: #ff0000;">ENTRY_DATE</SPAN>)&lt;<SPAN style="color: #000080;">num#</SPAN>(<SPAN style="color: #000080;">if</SPAN>(<SPAN style="color: #000080;">weekday</SPAN>(<SPAN style="color: #000080;">today</SPAN>())='Mo', <SPAN style="color: #000080;">date</SPAN>(<SPAN style="color: #000080;">today</SPAN>()-10), if(<SPAN style="color: #000080;">weekda</SPAN>y(<SPAN style="color: #000080;">today</SPAN>())='Sa', <SPAN style="color: #000080;">date</SPAN>(<SPAN style="color: #000080;">today</SPAN>()-9), date(<SPAN style="color: #000080;">today</SPAN>()-8))<STRONG style="font-size: 18pt;">)</STRONG>,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #000080;">nullcount</SPAN>(<SPAN style="color: #ff0000;">MISSION_OPEN</SPAN>), 0 )</P></BODY></HTML> Fri, 06 Feb 2015 10:06:12 GMT https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758139#M661862 simondachstr 2015-02-06T10:06:12Z Re: problem with expression script https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758140#M661863 <HTML><HEAD></HEAD><BODY><P>It looks like its your weekdays that are causing the issue. I think it should be 'Mon' and 'Sat'.</P><P></P><P>If you try that, it may help.</P></BODY></HTML> Fri, 06 Feb 2015 10:06:27 GMT https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758140#M661863 2015-02-06T10:06:27Z Re: problem with expression script https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758141#M661864 <HTML><HEAD></HEAD><BODY><P>yes is num# and i miss a ) but not in the script.</P><P>The weekday is correct </P></BODY></HTML> Fri, 06 Feb 2015 10:10:24 GMT https://community.qlik.com/t5/QlikView/problem-with-expression-script/m-p/758141#M661864 2015-02-06T10:10:24Z