topic Re: Aggregating measures in QlikView https://community.qlik.com/t5/QlikView/Aggregating-measures/m-p/1186770#M383900 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny. Much appreciated <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 19 Sep 2016 14:25:31 GMT 2016-09-19T14:25:31Z Aggregating measures https://community.qlik.com/t5/QlikView/Aggregating-measures/m-p/1186768#M383898 <HTML><HEAD></HEAD><BODY><P> Hi Community,</P><P></P><P>I'm trying to build the following column in the below table in QV. I need the max Sales person sales amount for the each row. </P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="504"><TBODY><TR><TD class="xl65" height="17" width="98">Sales_Person</TD><TD class="xl65" style="border-left: none;" width="98">Date</TD><TD class="xl65" style="border-left: none;" width="116">sum(Sales)</TD><TD class="xl65" style="border-left: none;" width="192">Max SP Sales (Requirement)</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Joy</TD><TD class="xl67" style="border-top: none; border-left: none;">1/1/2016</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$50.00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">150</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Joy</TD><TD class="xl67" style="border-top: none; border-left: none;">1/2/2016</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$150.00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">150</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Joy</TD><TD class="xl67" style="border-top: none; border-left: none;">1/3/2016</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$100.00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Tim</TD><TD class="xl67" style="border-top: none; border-left: none;">1/1/2016</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$30.00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">45</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Tim</TD><TD class="xl67" style="border-top: none; border-left: none;">1/2/2016</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$45.00</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">45</TD></TR></TBODY></TABLE><P></P><P>I was trying to use the following expression, but to no avail.&nbsp; </P><P></P><P>max(total &lt;Sales_Person&gt; aggr(sum(Sales), Sales_Person))</P><P></P><P>Please provide your guidance. Thanks V.</P></BODY></HTML> Fri, 16 Sep 2016 18:29:56 GMT https://community.qlik.com/t5/QlikView/Aggregating-measures/m-p/1186768#M383898 2016-09-16T18:29:56Z Re: Aggregating measures https://community.qlik.com/t5/QlikView/Aggregating-measures/m-p/1186769#M383899 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P><STRONG>Max(total &lt;Sales_Person&gt; aggr(sum(Sales), Sales_Person<SPAN style="color: #ff0000;">, Date</SPAN>))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/137758_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Fri, 16 Sep 2016 19:01:28 GMT https://community.qlik.com/t5/QlikView/Aggregating-measures/m-p/1186769#M383899 sunny_talwar 2016-09-16T19:01:28Z Re: Aggregating measures https://community.qlik.com/t5/QlikView/Aggregating-measures/m-p/1186770#M383900 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny. Much appreciated <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 19 Sep 2016 14:25:31 GMT https://community.qlik.com/t5/QlikView/Aggregating-measures/m-p/1186770#M383900 2016-09-19T14:25:31Z