topic Re: Aggr function can be used in Script ? in QlikView https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395451#M806185 <HTML><HEAD></HEAD><BODY><P>I see your formula is related to SUMIF <STRONG>range, criteria, [sum_range]</STRONG></P><P>In order to get such in script try to use early mentioned<STRONG> Group by</STRONG></P><P></P><P>GetExcelFormula:</P><P>LOAD</P><P>sum(columnD)</P><P><STRONG>Group by</STRONG> columnA;</P><P></P><P>LOAD * Inline [</P><P>columnA, columnD</P><P>A, 100</P><P>A, 50</P><P>B, 200</P><P>B, 70];</P></BODY></HTML> Tue, 06 Feb 2018 15:11:37 GMT maxsheva 2018-02-06T15:11:37Z Aggr function can be used in Script ? https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395446#M806180 <HTML><HEAD></HEAD><BODY><P>Hi Team - Can Aggr() can be used in script ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395446#M806180 bharani8 2020-11-25T16:16:04Z Re: Aggr function can be used in Script ? https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395447#M806181 <HTML><HEAD></HEAD><BODY><P>NO</P></BODY></HTML> Thu, 02 Nov 2017 05:32:00 GMT https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395447#M806181 tresB 2017-11-02T05:32:00Z Re: Aggr function can be used in Script ? https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395448#M806182 <HTML><HEAD></HEAD><BODY><P>No. The nearest script equivalent is Group By.</P></BODY></HTML> Thu, 02 Nov 2017 05:52:58 GMT https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395448#M806182 jonathandienst 2017-11-02T05:52:58Z Re: Aggr function can be used in Script ? https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395449#M806183 <HTML><HEAD></HEAD><BODY><P>What exactly are you trying to do?</P></BODY></HTML> Thu, 02 Nov 2017 11:45:57 GMT https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395449#M806183 sunny_talwar 2017-11-02T11:45:57Z Re: Aggr function can be used in Script ? https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395450#M806184 <HTML><HEAD></HEAD><BODY><P>I'm trying to build a new field in SCRIPT based on this SUMIF function:</P><P></P><P>=SUMIFS($A$2:$A$433360,A2,$D$2:$D$433360)</P></BODY></HTML> Fri, 19 Jan 2018 16:35:16 GMT https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395450#M806184 Anonymous 2018-01-19T16:35:16Z Re: Aggr function can be used in Script ? https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395451#M806185 <HTML><HEAD></HEAD><BODY><P>I see your formula is related to SUMIF <STRONG>range, criteria, [sum_range]</STRONG></P><P>In order to get such in script try to use early mentioned<STRONG> Group by</STRONG></P><P></P><P>GetExcelFormula:</P><P>LOAD</P><P>sum(columnD)</P><P><STRONG>Group by</STRONG> columnA;</P><P></P><P>LOAD * Inline [</P><P>columnA, columnD</P><P>A, 100</P><P>A, 50</P><P>B, 200</P><P>B, 70];</P></BODY></HTML> Tue, 06 Feb 2018 15:11:37 GMT https://community.qlik.com/t5/QlikView/Aggr-function-can-be-used-in-Script/m-p/1395451#M806185 maxsheva 2018-02-06T15:11:37Z