topic Re: Max () with a condition in QlikView https://community.qlik.com/t5/QlikView/Max-with-a-condition/m-p/973347#M332922 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I am glad you found the typo quick enough</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 17 Sep 2015 17:32:04 GMT sunny_talwar 2015-09-17T17:32:04Z Max () with a condition https://community.qlik.com/t5/QlikView/Max-with-a-condition/m-p/973344#M332919 <HTML><HEAD></HEAD><BODY><P>Hi QV Expert</P><P></P><P>I have a list of dates, and each date has a status of either completed or failed. I would like to create a variable for the max date when the status is completed. What would be the expression?&nbsp; I was trying set analysis, vMaxDate = Max({&lt;Status = {'Completed'}&gt;}Date), but it didn't work...</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 17 Sep 2015 17:21:46 GMT https://community.qlik.com/t5/QlikView/Max-with-a-condition/m-p/973344#M332919 Anonymous 2015-09-17T17:21:46Z Re: Max () with a condition https://community.qlik.com/t5/QlikView/Max-with-a-condition/m-p/973345#M332920 <HTML><HEAD></HEAD><BODY><P>I don't see anything wrong with the syntax.. what result do you see when you use this variable in a text box?</P></BODY></HTML> Thu, 17 Sep 2015 17:23:25 GMT https://community.qlik.com/t5/QlikView/Max-with-a-condition/m-p/973345#M332920 sunny_talwar 2015-09-17T17:23:25Z Re: Max () with a condition https://community.qlik.com/t5/QlikView/Max-with-a-condition/m-p/973346#M332921 <HTML><HEAD></HEAD><BODY><P>Ha. I had a typo. It's working now. Thanks</P></BODY></HTML> Thu, 17 Sep 2015 17:28:42 GMT https://community.qlik.com/t5/QlikView/Max-with-a-condition/m-p/973346#M332921 Anonymous 2015-09-17T17:28:42Z Re: Max () with a condition https://community.qlik.com/t5/QlikView/Max-with-a-condition/m-p/973347#M332922 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I am glad you found the typo quick enough</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 17 Sep 2015 17:32:04 GMT https://community.qlik.com/t5/QlikView/Max-with-a-condition/m-p/973347#M332922 sunny_talwar 2015-09-17T17:32:04Z