topic Re: Max value from row in App Development https://community.qlik.com/t5/App-Development/Max-value-from-row/m-p/1912479#M75202 <P>Solution:)</P> <P>MAX(TOTAL &lt;product&gt; AGGR(SUM(SALES), DATE, PRODUCT))</P> <P>&nbsp;</P> Thu, 31 Mar 2022 13:05:43 GMT Ssa90 2022-03-31T13:05:43Z Max value from row https://community.qlik.com/t5/App-Development/Max-value-from-row/m-p/1912428#M75198 <P>Hi!</P> <P>I have a pivot table:</P> <P>Product on rows</P> <P>Date on columns</P> <P>Measure - sales</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01&nbsp; &nbsp;02/01&nbsp; 03/01</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P> <P>B&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P> <P>C&nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9</P> <P>I want to calculate the maximum value for each row and display it in each column</P> <P>For product A&nbsp; - 10</P> <P>B - 4</P> <P>C - 11</P> <P>I want this result:</P> <P>01/01&nbsp; &nbsp;02/01&nbsp; 03/01</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P> <P>B&nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P> <P>C&nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11</P> <P>Tell me how to write such a formula?</P> <P>I understand how to sum by line(sum(total &lt;product&gt; sales)), but I don't understand how to get the maximum...</P> Thu, 31 Mar 2022 11:50:43 GMT https://community.qlik.com/t5/App-Development/Max-value-from-row/m-p/1912428#M75198 Ssa90 2022-03-31T11:50:43Z Re: Max value from row https://community.qlik.com/t5/App-Development/Max-value-from-row/m-p/1912479#M75202 <P>Solution:)</P> <P>MAX(TOTAL &lt;product&gt; AGGR(SUM(SALES), DATE, PRODUCT))</P> <P>&nbsp;</P> Thu, 31 Mar 2022 13:05:43 GMT https://community.qlik.com/t5/App-Development/Max-value-from-row/m-p/1912479#M75202 Ssa90 2022-03-31T13:05:43Z Re: Max value from row https://community.qlik.com/t5/App-Development/Max-value-from-row/m-p/1912483#M75204 <P>hi&nbsp;</P> <P>may be&nbsp;</P> <P>only(max(aggr(Sum(Sales),Date))&nbsp;</P> Thu, 31 Mar 2022 13:15:11 GMT https://community.qlik.com/t5/App-Development/Max-value-from-row/m-p/1912483#M75204 brunobertels 2022-03-31T13:15:11Z