https://community.qlik.com/t5/QlikView/Get-max-of-expression/m-p/1864580#M1216255 <P>Hi everyone,</P> <P>I'm struggling with expressions.</P> <P>I have an app like this :&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Boulanger_2-1638209782480.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/67574i2FD1E45257FEF77A/image-size/medium?v=v2&amp;px=400" role="button" title="Boulanger_2-1638209782480.png" alt="Boulanger_2-1638209782480.png" /></span></P> <P>User enter "allocation qty" then I have an expression(rangesum) which calculate "**bleep** Sum Qty".</P> <P>On background color expression I'm saying hilight the value if it's &lt; to the allocation qty&nbsp;</P> <P>What I need now is to extract the max number of this scenario (or the closest value to the variable "allocation qty")</P> <P>I've tried so many expression and functions (FirstSortedValue, Aggr, RangeMax, Max...)&nbsp;</P> <P>What would be your approach to find a solution to extract/store this value or filter the table above?&nbsp;</P> <P>Thanks a lot... I'm running out of ideas&nbsp;<span class="lia-unicode-emoji" title=":sad_but_relieved_face:">😥</span></P> Mon, 29 Nov 2021 18:18:13 GMT Boulanger 2021-11-29T18:18:13Z https://community.qlik.com/t5/QlikView/Get-max-of-expression/m-p/1864580#M1216255 <P>Hi everyone,</P> <P>I'm struggling with expressions.</P> <P>I have an app like this :&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Boulanger_2-1638209782480.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/67574i2FD1E45257FEF77A/image-size/medium?v=v2&amp;px=400" role="button" title="Boulanger_2-1638209782480.png" alt="Boulanger_2-1638209782480.png" /></span></P> <P>User enter "allocation qty" then I have an expression(rangesum) which calculate "**bleep** Sum Qty".</P> <P>On background color expression I'm saying hilight the value if it's &lt; to the allocation qty&nbsp;</P> <P>What I need now is to extract the max number of this scenario (or the closest value to the variable "allocation qty")</P> <P>I've tried so many expression and functions (FirstSortedValue, Aggr, RangeMax, Max...)&nbsp;</P> <P>What would be your approach to find a solution to extract/store this value or filter the table above?&nbsp;</P> <P>Thanks a lot... I'm running out of ideas&nbsp;<span class="lia-unicode-emoji" title=":sad_but_relieved_face:">😥</span></P> Mon, 29 Nov 2021 18:18:13 GMT https://community.qlik.com/t5/QlikView/Get-max-of-expression/m-p/1864580#M1216255 Boulanger 2021-11-29T18:18:13Z