https://community.qlik.com/t5/QlikView/Expression-help/m-p/2004272#M1221491 <P>Sum(Aggr(Avg(<FONT color="#FF0000"><STRONG>{&lt;trade_type_group_cd={'Swap'},WeekAnalysis={'Y'},exchange_cd={'*'}-{'-'}&gt;}</STRONG></FONT>Aggr(abs_pos_vol,our_reference,abs_pos_vol)),our_reference))</P> Mon, 14 Nov 2022 18:55:24 GMT BrunPierre 2022-11-14T18:55:24Z https://community.qlik.com/t5/QlikView/Expression-help/m-p/2004231#M1221490 <P>Hi,</P> <P>I have the following expression:</P> <P>Sum(Aggr(<BR />Avg(Aggr(<BR />abs_pos_vol<BR />, our_reference, abs_pos_vol))<BR />, our_reference))</P> <P>I would appreciate help with including;</P> <P>trade_type_group_cd={'Swap'}<BR />WeekAnalysis={'Y'}<BR />exchange_cd={'*'}-{'-'}</P> <P>within the expression.</P> <P>Thanks,<BR />Daniel</P> <P>&nbsp;</P> Mon, 14 Nov 2022 16:34:56 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/2004231#M1221490 danielnevitt 2022-11-14T16:34:56Z https://community.qlik.com/t5/QlikView/Expression-help/m-p/2004272#M1221491 <P>Sum(Aggr(Avg(<FONT color="#FF0000"><STRONG>{&lt;trade_type_group_cd={'Swap'},WeekAnalysis={'Y'},exchange_cd={'*'}-{'-'}&gt;}</STRONG></FONT>Aggr(abs_pos_vol,our_reference,abs_pos_vol)),our_reference))</P> Mon, 14 Nov 2022 18:55:24 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/2004272#M1221491 BrunPierre 2022-11-14T18:55:24Z