https://community.qlik.com/t5/App-Development/FirstSortedValue-based-on-AGGR-and-two-dimensions/m-p/1555663#M40089 <P>Change your expression to</P><P>firstsortedvalue(Country, -aggr(max(Sales), Product,Country))</P><P>&nbsp;</P><P>that should give you the correct answr</P> Tue, 12 Mar 2019 20:23:33 GMT dplr-rn 2019-03-12T20:23:33Z https://community.qlik.com/t5/App-Development/FirstSortedValue-based-on-AGGR-and-two-dimensions/m-p/1555651#M40087 <P>Hi Guys,</P><P>the situation is as presented below. On the left source data, on the right - what I'm trying to get. Important! I want to calculate it in a table on a sheet.</P><P><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fsv1.png" style="width: 522px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7840i71B79797C70326A3/image-dimensions/522x219?v=v2" width="522" height="219" role="button" title="fsv1.png" alt="fsv1.png" /></span></P><P>What I've tried is presented below but the FSV function returns incorrect results. Can you pls advice where is the mistake?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fsv2.png" style="width: 641px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7842iBED5288CEDB4DA56/image-dimensions/641x374?v=v2" width="641" height="374" role="button" title="fsv2.png" alt="fsv2.png" /></span></P><P>QVF is attached.</P><P>Thanks!</P> Sat, 16 Nov 2024 06:21:22 GMT https://community.qlik.com/t5/App-Development/FirstSortedValue-based-on-AGGR-and-two-dimensions/m-p/1555651#M40087 piotr-bratek 2024-11-16T06:21:22Z https://community.qlik.com/t5/App-Development/FirstSortedValue-based-on-AGGR-and-two-dimensions/m-p/1555663#M40089 <P>Change your expression to</P><P>firstsortedvalue(Country, -aggr(max(Sales), Product,Country))</P><P>&nbsp;</P><P>that should give you the correct answr</P> Tue, 12 Mar 2019 20:23:33 GMT https://community.qlik.com/t5/App-Development/FirstSortedValue-based-on-AGGR-and-two-dimensions/m-p/1555663#M40089 dplr-rn 2019-03-12T20:23:33Z