topic Re: Max(FirstDate) excluding last month using set analysis in QlikView https://community.qlik.com/t5/QlikView/Max-FirstDate-excluding-last-month-using-set-analysis/m-p/65588#M10894 <HTML><HEAD></HEAD><BODY><P>Can you share your data or sample application?</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 21 May 2018 13:34:53 GMT isingh30 2018-05-21T13:34:53Z Max(FirstDate) excluding last month using set analysis https://community.qlik.com/t5/QlikView/Max-FirstDate-excluding-last-month-using-set-analysis/m-p/65587#M10893 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I've been trying to work this one out all morning, and have done a search but can't find anything I can understand that answers this question. I'm pretty sure I've asked it myself, but can't find it on my dashboard :S</P><P></P><P>I have a list of clients, and a each client has various 'FirstDate' listed against them.</P><P>I want a straight table to show the max(FirstDate) excluding all where that max(FirstDate) is within this current month. I've tried with set analysis, using variables, using MonthName() and MonthStart(), just can't get it to work.</P><P></P><P>TIA.</P></BODY></HTML> Mon, 21 May 2018 12:54:50 GMT https://community.qlik.com/t5/QlikView/Max-FirstDate-excluding-last-month-using-set-analysis/m-p/65587#M10893 quilldew 2018-05-21T12:54:50Z Re: Max(FirstDate) excluding last month using set analysis https://community.qlik.com/t5/QlikView/Max-FirstDate-excluding-last-month-using-set-analysis/m-p/65588#M10894 <HTML><HEAD></HEAD><BODY><P>Can you share your data or sample application?</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 21 May 2018 13:34:53 GMT https://community.qlik.com/t5/QlikView/Max-FirstDate-excluding-last-month-using-set-analysis/m-p/65588#M10894 isingh30 2018-05-21T13:34:53Z Re: Max(FirstDate) excluding last month using set analysis https://community.qlik.com/t5/QlikView/Max-FirstDate-excluding-last-month-using-set-analysis/m-p/65589#M10895 <HTML><HEAD></HEAD><BODY><P>This is already resolved here</P><P><A href="https://community.qlik.com/thread/302093">Max(FirstDate) excluding last month using set analysis</A></P></BODY></HTML> Mon, 21 May 2018 13:37:12 GMT https://community.qlik.com/t5/QlikView/Max-FirstDate-excluding-last-month-using-set-analysis/m-p/65589#M10895 sunny_talwar 2018-05-21T13:37:12Z