topic Re: How to use date dynamically?? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-date-dynamically/m-p/778660#M1037684 <HTML><HEAD></HEAD><BODY><P>Try putting the variable within quotes like:</P><DIV>if</DIV><DIV><DIV> (<SPAN style="color: #0000ff;">len</SPAN>(<SPAN style="color: #800000;">Deactivated</SPAN>)&gt;1,<SPAN style="color: #800000;">Deactivated</SPAN>,'$(<STRONG><EM style="color: #808080;">vMax</EM></STRONG>)') <SPAN style="color: #0000ff;">As</SPAN> <SPAN style="color: #800000;">NewDeactivated </SPAN></DIV></DIV></BODY></HTML> Tue, 13 Jan 2015 09:11:40 GMT tresB 2015-01-13T09:11:40Z How to use date dynamically?? https://community.qlik.com/t5/QlikView/How-to-use-date-dynamically/m-p/778659#M1037682 <HTML><HEAD></HEAD><BODY><DIV><BR />Hi All,</DIV><DIV> </DIV><DIV>During Load, I am using below statement</DIV><DIV><DIV>-------<DIV>-------<DIV>if</DIV></DIV></DIV><DIV><DIV> </DIV><DIV>(<SPAN style="color: #0000ff;">len</SPAN>(<SPAN style="color: #800000;">Deactivated</SPAN>)&gt;1,<SPAN style="color: #800000;">Deactivated</SPAN>,'01/30/2017') <SPAN style="color: #0000ff;">As</SPAN> <SPAN style="color: #800000;">NewDeactivated </SPAN></DIV><DIV><SPAN style="color: #800000;">--------</SPAN></DIV><DIV><SPAN style="color: #800000;">--------</SPAN></DIV><DIV>It is working fine without any issue. But If I used below statement</DIV><DIV> </DIV><DIV><STRONG></STRONG><DIV>let</DIV><STRONG></STRONG><DIV> </DIV><DIV><STRONG><EM style="color: #808080;">vMax</EM></STRONG>= '01/30/2017';</DIV><DIV>Table:</DIV><DIV>Load</DIV><DIV>----------------</DIV><DIV>----------------</DIV><DIV><DIV>if</DIV><DIV><DIV> </DIV><DIV>(<SPAN style="color: #0000ff;">len</SPAN>(<SPAN style="color: #800000;">Deactivated</SPAN>)&gt;1,<SPAN style="color: #800000;">Deactivated</SPAN>,$(<STRONG><EM style="color: #808080;">vMax</EM></STRONG>)) <SPAN style="color: #0000ff;">As</SPAN> <SPAN style="color: #800000;">NewDeactivated </SPAN></DIV><DIV><SPAN style="color: #800000;">--------</SPAN></DIV><DIV><SPAN style="color: #800000;">--------</SPAN></DIV><DIV> </DIV><DIV><SPAN style="color: #000000;">Then it is not showing correct value for else part. Please help me to solve this.</SPAN></DIV><DIV> </DIV><DIV><SPAN style="color: #000000;">Thanks.</SPAN></DIV></DIV></DIV></DIV></DIV></DIV></BODY></HTML> Tue, 13 Jan 2015 09:08:25 GMT https://community.qlik.com/t5/QlikView/How-to-use-date-dynamically/m-p/778659#M1037682 soha1902 2015-01-13T09:08:25Z Re: How to use date dynamically?? https://community.qlik.com/t5/QlikView/How-to-use-date-dynamically/m-p/778660#M1037684 <HTML><HEAD></HEAD><BODY><P>Try putting the variable within quotes like:</P><DIV>if</DIV><DIV><DIV> (<SPAN style="color: #0000ff;">len</SPAN>(<SPAN style="color: #800000;">Deactivated</SPAN>)&gt;1,<SPAN style="color: #800000;">Deactivated</SPAN>,'$(<STRONG><EM style="color: #808080;">vMax</EM></STRONG>)') <SPAN style="color: #0000ff;">As</SPAN> <SPAN style="color: #800000;">NewDeactivated </SPAN></DIV></DIV></BODY></HTML> Tue, 13 Jan 2015 09:11:40 GMT https://community.qlik.com/t5/QlikView/How-to-use-date-dynamically/m-p/778660#M1037684 tresB 2015-01-13T09:11:40Z