https://community.qlik.com/t5/Data-Movement-Streaming/Firstsortedvalue/m-p/1870105#M105 <P>=FirstSortedValue(Product, -Aggr(Sum({&lt;Month={'July'}&gt;}Sales), Product))</P> Tue, 14 Dec 2021 04:15:07 GMT anat 2021-12-14T04:15:07Z https://community.qlik.com/t5/Data-Movement-Streaming/Firstsortedvalue/m-p/1869838#M104 <P>I have 3 fields: Sum(revenue), Product&nbsp; and Month(Jun and Jul only)</P> <P>Now I have to find highest revenue generating Product in the month of Jul.</P> <P>Can anyone help me out with an expression for the same?</P> Wed, 19 Mar 2025 23:08:30 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Firstsortedvalue/m-p/1869838#M104 GeorgePhilips23 2025-03-19T23:08:30Z https://community.qlik.com/t5/Data-Movement-Streaming/Firstsortedvalue/m-p/1870105#M105 <P>=FirstSortedValue(Product, -Aggr(Sum({&lt;Month={'July'}&gt;}Sales), Product))</P> Tue, 14 Dec 2021 04:15:07 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Firstsortedvalue/m-p/1870105#M105 anat 2021-12-14T04:15:07Z https://community.qlik.com/t5/Data-Movement-Streaming/Firstsortedvalue/m-p/1870108#M106 <P>THanks a lot&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/47358">@anat</a> !&nbsp;</P> Tue, 14 Dec 2021 04:19:59 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Firstsortedvalue/m-p/1870108#M106 GeorgePhilips23 2021-12-14T04:19:59Z