https://community.qlik.com/t5/QlikView/Maximum-value-in-pivot-table/m-p/1863998#M1216240 <P>Bingo.... Thanks champ</P> Fri, 26 Nov 2021 15:04:25 GMT swiftfahad 2021-11-26T15:04:25Z https://community.qlik.com/t5/QlikView/Maximum-value-in-pivot-table/m-p/1863390#M1216217 <P>how can I create a pivote table that show the sum(capacity) for the maximum refno.</P> <TABLE width="243"> <TBODY> <TR> <TD width="115">Memo</TD> <TD width="64">RefNo</TD> <TD width="64">Capacity</TD> </TR> <TR> <TD>ABC</TD> <TD>45</TD> <TD>2</TD> </TR> <TR> <TD>ABC</TD> <TD>46</TD> <TD>3</TD> </TR> <TR> <TD>ABC</TD> <TD>32</TD> <TD>14</TD> </TR> <TR> <TD>XYZ</TD> <TD>25</TD> <TD>2</TD> </TR> <TR> <TD>XYZ</TD> <TD>29</TD> <TD>17</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>required result is as follow plz suggest an expression i am using&nbsp;</P> <P>=max(aggr(sum(Capacity),RefNo)) but it show maximum value of capacity.</P> <TABLE width="242px"> <TBODY> <TR> <TD width="109px">Memo</TD> <TD width="63px">RefNo</TD> <TD width="70px">Capacity</TD> </TR> <TR> <TD width="109px">ABC</TD> <TD width="63px">46</TD> <TD width="70px">3</TD> </TR> <TR> <TD width="109px">XYZ</TD> <TD width="63px">29</TD> <TD width="70px">17</TD> </TR> <TR> <TD width="109px">&nbsp;</TD> <TD width="63px">&nbsp;</TD> <TD width="70px">&nbsp;</TD> </TR> <TR> <TD width="109px">&nbsp;</TD> <TD width="63px">&nbsp;</TD> <TD width="70px">&nbsp;</TD> </TR> <TR> <TD width="109px">&nbsp;</TD> <TD width="63px">&nbsp;</TD> <TD width="70px">&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>app is also attatched</P> Thu, 25 Nov 2021 06:32:41 GMT https://community.qlik.com/t5/QlikView/Maximum-value-in-pivot-table/m-p/1863390#M1216217 swiftfahad 2021-11-25T06:32:41Z https://community.qlik.com/t5/QlikView/Maximum-value-in-pivot-table/m-p/1863400#M1216220 <P>Like this?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tresesco_0-1637824051880.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/67402i585645E1134D5400/image-size/medium?v=v2&amp;px=400" role="button" title="tresesco_0-1637824051880.png" alt="tresesco_0-1637824051880.png" /></span></P> <P><FONT face="courier new,courier">FirstSortedValue(Aggr(Sum(Capacity),Memo,RefNo), -RefNo)</FONT></P> Thu, 25 Nov 2021 07:08:14 GMT https://community.qlik.com/t5/QlikView/Maximum-value-in-pivot-table/m-p/1863400#M1216220 tresB 2021-11-25T07:08:14Z https://community.qlik.com/t5/QlikView/Maximum-value-in-pivot-table/m-p/1863998#M1216240 <P>Bingo.... Thanks champ</P> Fri, 26 Nov 2021 15:04:25 GMT https://community.qlik.com/t5/QlikView/Maximum-value-in-pivot-table/m-p/1863998#M1216240 swiftfahad 2021-11-26T15:04:25Z