topic Re: set maximum date of each month in set analysis in QlikView https://community.qlik.com/t5/QlikView/set-maximum-date-of-each-month-in-set-analysis/m-p/1343663#M841918 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>FirstSortedValue(Aggr(Count(DISTINCT DJobID), Date, MonthYear), -Aggr(Date, Date, MonthYear))</STRONG></P></BODY></HTML> Wed, 19 Apr 2017 19:27:28 GMT sunny_talwar 2017-04-19T19:27:28Z set maximum date of each month in set analysis https://community.qlik.com/t5/QlikView/set-maximum-date-of-each-month-in-set-analysis/m-p/1343662#M841917 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>i want to show a count of <SPAN style="font-size: 13.3333px;">DJobID</SPAN> in MonthYear wise in straight table</P><P>but it won't consider all date it shout be maximum Date </P><P></P><P>so i use </P><P>count({&lt;Date = {'=Aggr(Max(Date),MonthYear)'}&gt;}DISTINCT&nbsp; DJobID)</P><P></P><P>for Jan 2013 it will be 6 but it shows only 5 What did i wrong?</P><P><IMG alt="Screenshot_3.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160549_Screenshot_3.png" style="height: 280px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/set-maximum-date-of-each-month-in-set-analysis/m-p/1343662#M841917 vengadeshpalani 2020-11-25T16:16:04Z Re: set maximum date of each month in set analysis https://community.qlik.com/t5/QlikView/set-maximum-date-of-each-month-in-set-analysis/m-p/1343663#M841918 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>FirstSortedValue(Aggr(Count(DISTINCT DJobID), Date, MonthYear), -Aggr(Date, Date, MonthYear))</STRONG></P></BODY></HTML> Wed, 19 Apr 2017 19:27:28 GMT https://community.qlik.com/t5/QlikView/set-maximum-date-of-each-month-in-set-analysis/m-p/1343663#M841918 sunny_talwar 2017-04-19T19:27:28Z