topic Re: Unable to pick max date in QlikView https://community.qlik.com/t5/QlikView/Unable-to-pick-max-date/m-p/801207#M282766 <HTML><HEAD></HEAD><BODY><P>Hi Niky, you can change your expression by:</P><P>Aggr(If(Date=Max(TOTAL &lt;Month&gt; Date), Sum(Stock)), Month, Date)</P><P></P><P>Using aggr inside set analysis is not working.</P></BODY></HTML> Fri, 13 Feb 2015 10:44:24 GMT rubenmarin 2015-02-13T10:44:24Z Unable to pick max date https://community.qlik.com/t5/QlikView/Unable-to-pick-max-date/m-p/801206#M282765 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Attached qvw sample.</P><P></P><P>I am unable to pick the last date available for the month. (Max Date available of the month)</P><P></P><P>Need your help.</P><P></P><P>Regards,</P><P>Niky Rathod</P></BODY></HTML> Fri, 13 Feb 2015 10:22:42 GMT https://community.qlik.com/t5/QlikView/Unable-to-pick-max-date/m-p/801206#M282765 Anonymous 2015-02-13T10:22:42Z Re: Unable to pick max date https://community.qlik.com/t5/QlikView/Unable-to-pick-max-date/m-p/801207#M282766 <HTML><HEAD></HEAD><BODY><P>Hi Niky, you can change your expression by:</P><P>Aggr(If(Date=Max(TOTAL &lt;Month&gt; Date), Sum(Stock)), Month, Date)</P><P></P><P>Using aggr inside set analysis is not working.</P></BODY></HTML> Fri, 13 Feb 2015 10:44:24 GMT https://community.qlik.com/t5/QlikView/Unable-to-pick-max-date/m-p/801207#M282766 rubenmarin 2015-02-13T10:44:24Z