topic condition in script in QlikView https://community.qlik.com/t5/QlikView/condition-in-script/m-p/47741#M7950 <HTML><HEAD></HEAD><BODY><P>I have this table :</P><P>Table:</P><P>Load [Sales Forcast],</P><P>date</P><P>from table</P><P></P><P>I want to add a field named <STRONG>Sales_forcast_valid</STRONG> with this condition :</P><P></P><P>if (today()&lt; date) <STRONG style="font-size: 13.3333px;">Sales_forcast_valid</STRONG><SPAN style="font-size: 13.3333px;">&nbsp; = <SPAN style="font-size: 13.3333px;">[Sales Forcast] </SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">else </SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Sales_forcast_valid</STRONG><SPAN style="font-size: 13.3333px;">&nbsp; =0</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks for help<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P></BODY></HTML> Tue, 03 Apr 2018 14:42:56 GMT zied_ahmed1 2018-04-03T14:42:56Z condition in script https://community.qlik.com/t5/QlikView/condition-in-script/m-p/47741#M7950 <HTML><HEAD></HEAD><BODY><P>I have this table :</P><P>Table:</P><P>Load [Sales Forcast],</P><P>date</P><P>from table</P><P></P><P>I want to add a field named <STRONG>Sales_forcast_valid</STRONG> with this condition :</P><P></P><P>if (today()&lt; date) <STRONG style="font-size: 13.3333px;">Sales_forcast_valid</STRONG><SPAN style="font-size: 13.3333px;">&nbsp; = <SPAN style="font-size: 13.3333px;">[Sales Forcast] </SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">else </SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">Sales_forcast_valid</STRONG><SPAN style="font-size: 13.3333px;">&nbsp; =0</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks for help<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P></BODY></HTML> Tue, 03 Apr 2018 14:42:56 GMT https://community.qlik.com/t5/QlikView/condition-in-script/m-p/47741#M7950 zied_ahmed1 2018-04-03T14:42:56Z Re: condition in script https://community.qlik.com/t5/QlikView/condition-in-script/m-p/47742#M7951 <HTML><HEAD></HEAD><BODY><P>if(today()&lt;date,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[Sales Forcast],0) as <STRONG style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sales_forcast_valid,</STRONG></SPAN></P></BODY></HTML> Tue, 03 Apr 2018 14:53:18 GMT https://community.qlik.com/t5/QlikView/condition-in-script/m-p/47742#M7951 m_woolf 2018-04-03T14:53:18Z