https://community.qlik.com/t5/QlikView/I-want-all-values-to-be-displayed-in-the-table-by-CodePart/m-p/2049368#M1222944 <P>Hi</P> <P>Might be, try like this</P> <P><SPAN>Max(Total&lt;CodePart&gt; (Aggr( Sum( Aggr(if(CycleTime_Sec &gt; 0 ,CycleTime_Sec,'0'),Number,WSGroup)/((sum(INPUT) + Sum([INTERNAL])) - sum(Aggr(DISTINCT xWorkOrder, CodePart,Part,Number)) + Sum([TEST])),CodePart,Part)))</SPAN></P> Wed, 15 Mar 2023 08:23:28 GMT MayilVahanan 2023-03-15T08:23:28Z https://community.qlik.com/t5/QlikView/I-want-all-values-to-be-displayed-in-the-table-by-CodePart/m-p/2049331#M1222943 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1678864208133.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/102790iA6CDBD362A4DF25D/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1678864208133.png" alt="Sxbbb_0-1678864208133.png" /></span></P> <P>I want Max=15 value of CodePart='A3030#1' from every cell in the table.</P> <P>and&nbsp;Other CodePart also display the Max value. every line in the table</P> <P>like this</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1678864821126.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/102793iC401D34647E4710E/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1678864821126.png" alt="Sxbbb_0-1678864821126.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_1-1678864837185.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/102794i2258C260A1B312C2/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_1-1678864837185.png" alt="Sxbbb_1-1678864837185.png" /></span></P> <P>I'm currently trying this code :</P> <P>Aggr(Max( (Aggr( Sum( Aggr(if(CycleTime_Sec &gt; 0 ,CycleTime_Sec,'0'),Number,WSGroup)/((sum(INPUT) + Sum([INTERNAL])) - sum(Aggr(DISTINCT xWorkOrder, CodePart,Part,Number)) + Sum([TEST])),CodePart,Part))),CodePart)</P> <P>&nbsp;</P> Wed, 15 Mar 2023 07:25:01 GMT https://community.qlik.com/t5/QlikView/I-want-all-values-to-be-displayed-in-the-table-by-CodePart/m-p/2049331#M1222943 Sxbbb 2023-03-15T07:25:01Z https://community.qlik.com/t5/QlikView/I-want-all-values-to-be-displayed-in-the-table-by-CodePart/m-p/2049368#M1222944 <P>Hi</P> <P>Might be, try like this</P> <P><SPAN>Max(Total&lt;CodePart&gt; (Aggr( Sum( Aggr(if(CycleTime_Sec &gt; 0 ,CycleTime_Sec,'0'),Number,WSGroup)/((sum(INPUT) + Sum([INTERNAL])) - sum(Aggr(DISTINCT xWorkOrder, CodePart,Part,Number)) + Sum([TEST])),CodePart,Part)))</SPAN></P> Wed, 15 Mar 2023 08:23:28 GMT https://community.qlik.com/t5/QlikView/I-want-all-values-to-be-displayed-in-the-table-by-CodePart/m-p/2049368#M1222944 MayilVahanan 2023-03-15T08:23:28Z https://community.qlik.com/t5/QlikView/I-want-all-values-to-be-displayed-in-the-table-by-CodePart/m-p/2049371#M1222945 <P>Thank you very much, I can do what I want.</P> Wed, 15 Mar 2023 08:26:21 GMT https://community.qlik.com/t5/QlikView/I-want-all-values-to-be-displayed-in-the-table-by-CodePart/m-p/2049371#M1222945 Sxbbb 2023-03-15T08:26:21Z