topic Straight Table Filter with Dates from Calander in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-Filter-with-Dates-from-Calander/m-p/306922#M1199825 <HTML><HEAD></HEAD><BODY><P>I have a straight table. With Date, Name, and BookedAmount.</P><P>I have two Calander Objects. One takes A variable called StartDate, the other takes a variable called EndDate.</P><P>I just want my table to show the Dates, Names, and BookedAmounts that are between StartDate and EndDate.</P><P>I've been looking at other forum posts and trying to adapt a formula for the correct expression to use for my Bookedamount, but nothing has worked. (I've tried forumlas that are just wrong, Macros with VB code that just do nothing etc. etc.)</P><P>Please help, there has to be an easy way to get this done.</P></BODY></HTML> Fri, 18 Feb 2011 21:22:42 GMT 2011-02-18T21:22:42Z Straight Table Filter with Dates from Calander https://community.qlik.com/t5/QlikView/Straight-Table-Filter-with-Dates-from-Calander/m-p/306922#M1199825 <HTML><HEAD></HEAD><BODY><P>I have a straight table. With Date, Name, and BookedAmount.</P><P>I have two Calander Objects. One takes A variable called StartDate, the other takes a variable called EndDate.</P><P>I just want my table to show the Dates, Names, and BookedAmounts that are between StartDate and EndDate.</P><P>I've been looking at other forum posts and trying to adapt a formula for the correct expression to use for my Bookedamount, but nothing has worked. (I've tried forumlas that are just wrong, Macros with VB code that just do nothing etc. etc.)</P><P>Please help, there has to be an easy way to get this done.</P></BODY></HTML> Fri, 18 Feb 2011 21:22:42 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Filter-with-Dates-from-Calander/m-p/306922#M1199825 2011-02-18T21:22:42Z Straight Table Filter with Dates from Calander https://community.qlik.com/t5/QlikView/Straight-Table-Filter-with-Dates-from-Calander/m-p/306923#M1199826 <HTML><HEAD></HEAD><BODY><P>Resolved:</P><P>Aggr(Date&gt;=StartDate and Date&lt;=EndDate,BookedAmount)</P><P></P><P>All I needed to do was put this into an expression in my straight table. Seems to work fine. I just now hide this column.</P></BODY></HTML> Fri, 18 Feb 2011 21:43:29 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Filter-with-Dates-from-Calander/m-p/306923#M1199826 2011-02-18T21:43:29Z