topic Re: Help with Set Analysis on dates in QlikView https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-on-dates/m-p/530476#M198294 <HTML><HEAD></HEAD><BODY><P>Can you provide sample app? </P></BODY></HTML> Mon, 26 Aug 2013 13:56:36 GMT 2013-08-26T13:56:36Z Help with Set Analysis on dates https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-on-dates/m-p/530475#M198293 <HTML><HEAD></HEAD><BODY><P>I am trying to look at historical dates as of a certain point in time.&nbsp; We have a rec_end_date and a rec_start_date.&nbsp; My set Analysis looks at the Max rec_end_date without issue but when I try to then reduce the data down to a less than or equal to start date it just does nothing in the pivot table.&nbsp; I am using a calendar object with a button to set the variable for vD_Date.&nbsp; </P><P></P><P>sum ({&lt;rec_end_date={'$(=Max(rec_end_date))'}, REC_START_DATE = {"&lt;=$(=Date(vD_Date)"}&gt;}[Actual Hrs])</P></BODY></HTML> Mon, 26 Aug 2013 13:32:47 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-on-dates/m-p/530475#M198293 2013-08-26T13:32:47Z Re: Help with Set Analysis on dates https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-on-dates/m-p/530476#M198294 <HTML><HEAD></HEAD><BODY><P>Can you provide sample app? </P></BODY></HTML> Mon, 26 Aug 2013 13:56:36 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-on-dates/m-p/530476#M198294 2013-08-26T13:56:36Z Re: Help with Set Analysis on dates https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-on-dates/m-p/530477#M198295 <HTML><HEAD></HEAD><BODY><P>I figured it out missing a ) after the vD_Date.&nbsp; With Quotes around that set of code the colors are not available and just missed it.&nbsp; </P></BODY></HTML> Mon, 26 Aug 2013 14:50:07 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-on-dates/m-p/530477#M198295 2013-08-26T14:50:07Z