https://community.qlik.com/t5/QlikView/Expression-help/m-p/1733077#M721170 <P>Dear all,</P><P>I have the below expression and would really appreciate some help to add when the trade_dt_weekname = 2020/31</P><P>Sum(Aggr(<BR />Avg(Aggr(<BR />abs_pos_vol<BR />, our_reference, abs_pos_vol))<BR />, our_reference))</P><P>Regards,<BR />Daniel</P> Wed, 25 Nov 2020 16:16:04 GMT danielnevitt 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Expression-help/m-p/1733077#M721170 <P>Dear all,</P><P>I have the below expression and would really appreciate some help to add when the trade_dt_weekname = 2020/31</P><P>Sum(Aggr(<BR />Avg(Aggr(<BR />abs_pos_vol<BR />, our_reference, abs_pos_vol))<BR />, our_reference))</P><P>Regards,<BR />Daniel</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/1733077#M721170 danielnevitt 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Expression-help/m-p/1733104#M721171 <P>may be below</P><LI-CODE lang="javascript">Sum({&lt;trade_dt_weekname = {'2020/31'}&gt;}Aggr(Avg({&lt;trade_dt_weekname = {'2020/31'}&gt;}Aggr(sum({&lt;trade_dt_weekname = {'2020/31'}&gt;}abs_pos_vol), our_reference, abs_pos_vol)), our_reference))</LI-CODE> Tue, 04 Aug 2020 12:58:58 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/1733104#M721171 Kushal_Chawda 2020-08-04T12:58:58Z