topic Re: How to show a specific value of an aggro function? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-a-specific-value-of-an-aggro-function/m-p/780194#M276460 <HTML><HEAD></HEAD><BODY><P>Privet Alex, kak dela?</P><P></P><P>not sure I totally understand your question, but <SPAN style="font-size: 10pt; line-height: 1.5em;">how about this expression:</SPAN></P><P><STRONG>FirstSortedValue(IdShop, -aggr(sum(Sales),branch,week,IdShop))</STRONG></P><P></P><P>you can get some ideas here if it does not work in your case</P><P><A href="https://community.qlik.com/docs/DOC-3857">QlikView Technical Brief - AGGR.docx</A></P><P></P><P>Boris</P></BODY></HTML> Sat, 06 Dec 2014 03:11:39 GMT Anonymous 2014-12-06T03:11:39Z How to show a specific value of an aggro function? https://community.qlik.com/t5/QlikView/How-to-show-a-specific-value-of-an-aggro-function/m-p/780193#M276459 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am having a situation and i just can't find an answer. </P><P></P><P>I made a pivot table. Rows are "Branches" and columns are "weeks". Each branch can have multiple shops.</P><P></P><P>The idea is to show the IdShop with the max sales in the week. So Max(aggr(Sum(Sales), week, branch, IdShop) shows the right sales numbers. But i need to show the IdShop to which each calculated Max Sum Sales belong. How do i return the value of the IdShop, that answers the Max(aggr(Sum(Sales), week, branch, IdShop) criteria? Tried to do it with the&nbsp; IF statement ( If (Max(aggr(Sum(Sales), week, branch, IdShop), IdShop), but it shows only one value of single IdShop in pivot table. Hopefully you can understand what i just wrote. I would love to attach the qwv file, but it is all in Russian though.</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 04 Dec 2014 22:23:48 GMT https://community.qlik.com/t5/QlikView/How-to-show-a-specific-value-of-an-aggro-function/m-p/780193#M276459 2014-12-04T22:23:48Z Re: How to show a specific value of an aggro function? https://community.qlik.com/t5/QlikView/How-to-show-a-specific-value-of-an-aggro-function/m-p/780194#M276460 <HTML><HEAD></HEAD><BODY><P>Privet Alex, kak dela?</P><P></P><P>not sure I totally understand your question, but <SPAN style="font-size: 10pt; line-height: 1.5em;">how about this expression:</SPAN></P><P><STRONG>FirstSortedValue(IdShop, -aggr(sum(Sales),branch,week,IdShop))</STRONG></P><P></P><P>you can get some ideas here if it does not work in your case</P><P><A href="https://community.qlik.com/docs/DOC-3857">QlikView Technical Brief - AGGR.docx</A></P><P></P><P>Boris</P></BODY></HTML> Sat, 06 Dec 2014 03:11:39 GMT https://community.qlik.com/t5/QlikView/How-to-show-a-specific-value-of-an-aggro-function/m-p/780194#M276460 Anonymous 2014-12-06T03:11:39Z