topic Get Max Date selling rate Using set analysis in QlikView https://community.qlik.com/t5/QlikView/Get-Max-Date-selling-rate-Using-set-analysis/m-p/389601#M1167144 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>How to get Max Date selling rate Using set analysis.partwise ,itemwise.</P><P></P><P><STRONG>I select Year or Month</STRONG></P><P></P><P>Not Working:</P><P></P><P>My Expression:</P><P></P><P>ONLY({&lt;YEAR=,Month=,SalesDate={"=((Aggr(NoDistinct Max(SalesDate),PARTYID,Item)))"}&gt;} Rate)</P><P></P><P>My sample file attached.Pls hlep.</P><P></P><P>Regards,</P><P>Muni</P></BODY></HTML> Mon, 10 Sep 2012 07:23:47 GMT muniyandi 2012-09-10T07:23:47Z Get Max Date selling rate Using set analysis https://community.qlik.com/t5/QlikView/Get-Max-Date-selling-rate-Using-set-analysis/m-p/389601#M1167144 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>How to get Max Date selling rate Using set analysis.partwise ,itemwise.</P><P></P><P><STRONG>I select Year or Month</STRONG></P><P></P><P>Not Working:</P><P></P><P>My Expression:</P><P></P><P>ONLY({&lt;YEAR=,Month=,SalesDate={"=((Aggr(NoDistinct Max(SalesDate),PARTYID,Item)))"}&gt;} Rate)</P><P></P><P>My sample file attached.Pls hlep.</P><P></P><P>Regards,</P><P>Muni</P></BODY></HTML> Mon, 10 Sep 2012 07:23:47 GMT https://community.qlik.com/t5/QlikView/Get-Max-Date-selling-rate-Using-set-analysis/m-p/389601#M1167144 muniyandi 2012-09-10T07:23:47Z Re: Get Max Date selling rate Using set analysis https://community.qlik.com/t5/QlikView/Get-Max-Date-selling-rate-Using-set-analysis/m-p/389602#M1167145 <HTML><HEAD></HEAD><BODY><P>Why do you duplicate your questions ?</P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/thread/61289?tstart=0" title="http://community.qlik.com/thread/61289?tstart=0">http://community.qlik.com/thread/61289?tstart=0</A></P></BODY></HTML> Mon, 10 Sep 2012 08:00:17 GMT https://community.qlik.com/t5/QlikView/Get-Max-Date-selling-rate-Using-set-analysis/m-p/389602#M1167145 whiteline 2012-09-10T08:00:17Z