topic Re: date in QlikView

topic Re: date in QlikView https://community.qlik.com/t5/QlikView/date/m-p/404324#M1157700 <HTML><HEAD></HEAD><BODY><P>That would be today(). So like: </P><P><SPAN style="color: #0000ff; font-size: 8pt;">  </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>SUM<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">DATE2</SPAN><SPAN style="color: #0000ff; font-size: 8pt;"> >= </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">() </SPAN><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">() - </SPAN><SPAN style="color: #800000; font-size: 8pt;">DATE1, '0'</SPAN><SPAN style="font-size: 8pt;">))) </SPAN></SPAN></P><P></P></BODY></HTML> Mon, 04 Mar 2013 15:17:11 GMT 2013-03-04T15:17:11Z date https://community.qlik.com/t5/QlikView/date/m-p/404323#M1157699 <HTML><HEAD></HEAD><BODY><P>Good afternoon, I need an expression:</P><P></P><P></P><P>ex. greater than today's date</P><P></P><P></P><P>= > now () ??</P></BODY></HTML> Mon, 04 Mar 2013 15:13:57 GMT https://community.qlik.com/t5/QlikView/date/m-p/404323#M1157699 2013-03-04T15:13:57Z Re: date https://community.qlik.com/t5/QlikView/date/m-p/404324#M1157700 <HTML><HEAD></HEAD><BODY><P>That would be today(). So like: </P><P><SPAN style="color: #0000ff; font-size: 8pt;">  </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>SUM<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">DATE2</SPAN><SPAN style="color: #0000ff; font-size: 8pt;"> >= </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">() </SPAN><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">() - </SPAN><SPAN style="color: #800000; font-size: 8pt;">DATE1, '0'</SPAN><SPAN style="font-size: 8pt;">))) </SPAN></SPAN></P><P></P></BODY></HTML> Mon, 04 Mar 2013 15:17:11 GMT https://community.qlik.com/t5/QlikView/date/m-p/404324#M1157700 2013-03-04T15:17:11Z Re: date https://community.qlik.com/t5/QlikView/date/m-p/404325#M1157701 <HTML><HEAD></HEAD><BODY><P></P><P>Hi,</P><P></P><P>Try below expression</P><P></P><P>=Sum({<DateDimension={'>=$(=Today())'}>} Sales)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 04 Mar 2013 15:19:53 GMT https://community.qlik.com/t5/QlikView/date/m-p/404325#M1157701 jagan 2013-03-04T15:19:53Z