topic What this expression means in QlikView https://community.qlik.com/t5/QlikView/What-this-expression-means/m-p/1114463#M905677 <HTML><HEAD></HEAD><BODY><P>max(all aggr(Sum({$&lt;Year={$(=Max(Year))}&gt;}&nbsp; Sales/$(vCurrency)) / Sum({$&lt;Year={$(=Max(Year))}&gt;}&nbsp; Budget_$(vCurrency)), Customer))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT arethaking 2020-11-25T16:16:04Z What this expression means https://community.qlik.com/t5/QlikView/What-this-expression-means/m-p/1114463#M905677 <HTML><HEAD></HEAD><BODY><P>max(all aggr(Sum({$&lt;Year={$(=Max(Year))}&gt;}&nbsp; Sales/$(vCurrency)) / Sum({$&lt;Year={$(=Max(Year))}&gt;}&nbsp; Budget_$(vCurrency)), Customer))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/What-this-expression-means/m-p/1114463#M905677 arethaking 2020-11-25T16:16:04Z Re: What this expression means https://community.qlik.com/t5/QlikView/What-this-expression-means/m-p/1114464#M905678 <HTML><HEAD></HEAD><BODY><P>Of the maximum year in your current selection, calculated the Sales divided by the Budget and do this for every Customer. Take the maximum value of that list.</P></BODY></HTML> Sat, 25 Jun 2016 15:34:55 GMT https://community.qlik.com/t5/QlikView/What-this-expression-means/m-p/1114464#M905678 oknotsen 2016-06-25T15:34:55Z