topic How do I do a date comparision in set analysis in QlikView https://community.qlik.com/t5/QlikView/How-do-I-do-a-date-comparision-in-set-analysis/m-p/392398#M146354 <HTML><HEAD></HEAD><BODY><P>=Sum({$&lt;date#([Hire Date Year],'DD.MM.YYYY')={"&lt;="date#(MonthStart((Addmonths(Today(), -1))), 'DD.MM.YYYY')"}, [ Status]={'Active'}&gt;}[Hours])</P><P></P><P></P><P>make sure they were hired before or equal to the first day of last month and their status is active</P></BODY></HTML> Tue, 21 May 2013 18:17:55 GMT 2013-05-21T18:17:55Z How do I do a date comparision in set analysis https://community.qlik.com/t5/QlikView/How-do-I-do-a-date-comparision-in-set-analysis/m-p/392398#M146354 <HTML><HEAD></HEAD><BODY><P>=Sum({$&lt;date#([Hire Date Year],'DD.MM.YYYY')={"&lt;="date#(MonthStart((Addmonths(Today(), -1))), 'DD.MM.YYYY')"}, [ Status]={'Active'}&gt;}[Hours])</P><P></P><P></P><P>make sure they were hired before or equal to the first day of last month and their status is active</P></BODY></HTML> Tue, 21 May 2013 18:17:55 GMT https://community.qlik.com/t5/QlikView/How-do-I-do-a-date-comparision-in-set-analysis/m-p/392398#M146354 2013-05-21T18:17:55Z