topic Sub aggregation in QlikView https://community.qlik.com/t5/QlikView/Sub-aggregation/m-p/986726#M961506 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a few traders, each trades different types of instruments. Each trade gets a deal ID.</P><P>There are deals (swap trades) that have both positive and negative values to the deal, i.e. the deal has two lines in the table.</P><P>I'd like to net the each deal values and then calculate the absolute total values for each trader.</P><P></P><P>Where is the best place to add that sub aggregation - in the table load script (how?) or as an expression in a chart object?</P><P>I created a separate table with just the deal ID and trade amounts. Then wanted to show each trader's total absolute trade amount.</P><P>I tried the latter with:</P><P></P><P>Aggr(DISTINCT Sum(Trade_Amount),deal_ID) </P><P>But got one single aggregation.</P><P></P><P>Thanks!</P><P>Michael</P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Thu, 15 Oct 2015 13:36:39 GMT 2015-10-15T13:36:39Z Sub aggregation https://community.qlik.com/t5/QlikView/Sub-aggregation/m-p/986726#M961506 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a few traders, each trades different types of instruments. Each trade gets a deal ID.</P><P>There are deals (swap trades) that have both positive and negative values to the deal, i.e. the deal has two lines in the table.</P><P>I'd like to net the each deal values and then calculate the absolute total values for each trader.</P><P></P><P>Where is the best place to add that sub aggregation - in the table load script (how?) or as an expression in a chart object?</P><P>I created a separate table with just the deal ID and trade amounts. Then wanted to show each trader's total absolute trade amount.</P><P>I tried the latter with:</P><P></P><P>Aggr(DISTINCT Sum(Trade_Amount),deal_ID) </P><P>But got one single aggregation.</P><P></P><P>Thanks!</P><P>Michael</P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Thu, 15 Oct 2015 13:36:39 GMT https://community.qlik.com/t5/QlikView/Sub-aggregation/m-p/986726#M961506 2015-10-15T13:36:39Z