https://community.qlik.com/t5/App-Development/QlikView-using-MAX-in-chart/m-p/2142217#M92917 <P>Try this</P> <P>=If(Aggr(Sum(Units_Sold), Customer) = Max(Total Aggr(Sum(Units_Sold), Customer)), Sum(Units_Sold))</P> Wed, 29 Nov 2023 06:20:12 GMT BrunPierre 2023-11-29T06:20:12Z https://community.qlik.com/t5/App-Development/QlikView-using-MAX-in-chart/m-p/2142145#M92910 <P>Hi there,</P> <P>I am trying to use the 'MAX' function in a chart to to get the highest sum of units sold over 4 week period by customer.&nbsp;</P> <P>Customer C has the highest combined total over the 4 weeks with 28 units sold.&nbsp;</P> <P>What is the best expression to use to get '28' in my chart?</P> <P>Thanks in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> <P>&nbsp;</P> <TABLE width="273"> <TBODY> <TR> <TD width="100">Customer</TD> <TD width="82">Week&nbsp;</TD> <TD width="91">Units_Sold</TD> </TR> <TR> <TD>Customer A</TD> <TD>1</TD> <TD>3</TD> </TR> <TR> <TD>Customer A</TD> <TD>2</TD> <TD>6</TD> </TR> <TR> <TD>Customer A</TD> <TD>3</TD> <TD>5</TD> </TR> <TR> <TD>Customer A</TD> <TD>4</TD> <TD>4</TD> </TR> <TR> <TD>Customer B</TD> <TD>1</TD> <TD>2</TD> </TR> <TR> <TD>Customer B</TD> <TD>2</TD> <TD>6</TD> </TR> <TR> <TD>Customer B</TD> <TD>3</TD> <TD>8</TD> </TR> <TR> <TD>Customer B</TD> <TD>4</TD> <TD>9</TD> </TR> <TR> <TD>Customer C</TD> <TD>1</TD> <TD>4</TD> </TR> <TR> <TD>Customer C</TD> <TD>2</TD> <TD>8</TD> </TR> <TR> <TD>Customer C</TD> <TD>3</TD> <TD>7</TD> </TR> <TR> <TD>Customer C</TD> <TD>4</TD> <TD>9</TD> </TR> <TR> <TD>Customer D</TD> <TD>1</TD> <TD>4</TD> </TR> <TR> <TD>Customer D</TD> <TD>2</TD> <TD>3</TD> </TR> <TR> <TD>Customer D</TD> <TD>3</TD> <TD>5</TD> </TR> <TR> <TD>Customer D</TD> <TD>4</TD> <TD>6</TD> </TR> <TR> <TD>Customer E</TD> <TD>1</TD> <TD>2</TD> </TR> <TR> <TD>Customer E</TD> <TD>2</TD> <TD>4</TD> </TR> <TR> <TD>Customer E</TD> <TD>3</TD> <TD>5</TD> </TR> <TR> <TD>Customer E</TD> <TD>4</TD> <TD>6</TD> </TR> </TBODY> </TABLE> Tue, 28 Nov 2023 21:25:10 GMT https://community.qlik.com/t5/App-Development/QlikView-using-MAX-in-chart/m-p/2142145#M92910 NickBentley 2023-11-28T21:25:10Z https://community.qlik.com/t5/App-Development/QlikView-using-MAX-in-chart/m-p/2142217#M92917 <P>Try this</P> <P>=If(Aggr(Sum(Units_Sold), Customer) = Max(Total Aggr(Sum(Units_Sold), Customer)), Sum(Units_Sold))</P> Wed, 29 Nov 2023 06:20:12 GMT https://community.qlik.com/t5/App-Development/QlikView-using-MAX-in-chart/m-p/2142217#M92917 BrunPierre 2023-11-29T06:20:12Z