topic Re: current day in QlikView https://community.qlik.com/t5/QlikView/current-day/m-p/448806#M167468 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This should do it:</P><P></P><P>if(datefield &gt; today(), 'שולם' ,'צק דחוי') as status</P><P></P><P>Regards</P><P>Jonathan</P><P></P><P>Fixed missing closing bracket</P></BODY></HTML> Tue, 20 Nov 2012 05:59:14 GMT jonathandienst 2012-11-20T05:59:14Z current day https://community.qlik.com/t5/QlikView/current-day/m-p/448805#M167467 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i have field with date, i want to show all the line that <SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">Greater than</SPAN></SPAN> today date, </P><P>it's obvious that today date should <SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">Refers</SPAN></SPAN> to the current date iche day.</P><P>how can write in the script ...</P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>if[<SPAN style="color: #800000; font-size: 8pt;">(datefield]</SPAN><SPAN style="font-size: 8pt;">&gt;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[datefield</SPAN><SPAN style="font-size: 8pt;">),'שולם','צק דחוי') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as(</SPAN><SPAN style="color: #800000; font-size: 8pt;">status)</SPAN></P><P></P><P><SPAN style="color: #800000;">thanks'</SPAN></P><P><SPAN style="color: #800000;">yarin</SPAN></P> <P></P><P></P></BODY></HTML> Tue, 20 Nov 2012 05:53:53 GMT https://community.qlik.com/t5/QlikView/current-day/m-p/448805#M167467 Anonymous 2012-11-20T05:53:53Z Re: current day https://community.qlik.com/t5/QlikView/current-day/m-p/448806#M167468 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This should do it:</P><P></P><P>if(datefield &gt; today(), 'שולם' ,'צק דחוי') as status</P><P></P><P>Regards</P><P>Jonathan</P><P></P><P>Fixed missing closing bracket</P></BODY></HTML> Tue, 20 Nov 2012 05:59:14 GMT https://community.qlik.com/t5/QlikView/current-day/m-p/448806#M167468 jonathandienst 2012-11-20T05:59:14Z