topic Re: Last 7 Days Date in ListBox in QlikView https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744270#M536312 <HTML><HEAD></HEAD><BODY><P>try this&nbsp; in your List Box Expression</P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="font-size: 12pt;">if(yourdatefield &gt; =Date(Today()-7),yourdatefield)</SPAN></P></BODY></HTML> Thu, 13 Nov 2014 21:19:00 GMT swarup_malli 2014-11-13T21:19:00Z Last 7 Days Date in ListBox https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744269#M536311 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>How can we have last 7 days date in listbox.</P><P></P><P>Please help</P><P></P><P>Regards,</P><P>Shree Angane</P></BODY></HTML> Thu, 13 Nov 2014 20:57:30 GMT https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744269#M536311 Anonymous 2014-11-13T20:57:30Z Re: Last 7 Days Date in ListBox https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744270#M536312 <HTML><HEAD></HEAD><BODY><P>try this&nbsp; in your List Box Expression</P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="font-size: 12pt;">if(yourdatefield &gt; =Date(Today()-7),yourdatefield)</SPAN></P></BODY></HTML> Thu, 13 Nov 2014 21:19:00 GMT https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744270#M536312 swarup_malli 2014-11-13T21:19:00Z Re: Last 7 Days Date in ListBox https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744271#M536313 <HTML><HEAD></HEAD><BODY><P>Refer to this post</P><P><A href="https://community.qlik.com/thread/12328">Select last 7 Days in QlikView Document</A></P></BODY></HTML> Thu, 13 Nov 2014 21:19:19 GMT https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744271#M536313 2014-11-13T21:19:19Z Re: Last 7 Days Date in ListBox https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744272#M536314 <HTML><HEAD></HEAD><BODY><P>=if(date &gt;= (today()-7), date)</P></BODY></HTML> Thu, 13 Nov 2014 21:22:49 GMT https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744272#M536314 maxgro 2014-11-13T21:22:49Z Re: Last 7 Days Date in ListBox https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744273#M536315 <HTML><HEAD></HEAD><BODY><P>Use below in your List Box Expression</P><P></P><P>=if(DateField &gt; Date(Today()-7),DateField)</P></BODY></HTML> Thu, 13 Nov 2014 21:24:25 GMT https://community.qlik.com/t5/QlikView/Last-7-Days-Date-in-ListBox/m-p/744273#M536315 MK_QSL 2014-11-13T21:24:25Z