topic AGGR with additional dimension in QlikView https://community.qlik.com/t5/QlikView/AGGR-with-additional-dimension/m-p/735624#M475986 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>In the below aggregation which works well&nbsp; I also want to add only 'NEW' products (TYPE = "NEW').</P><P>Could someone tell me how would I include also TYPE = 'NEW' in the below aggregation so that it only sums up 'NEW'</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>=-</P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">only</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">INFPERIOD</SPAN><SPAN style="font-size: 8pt;">)='$(vInforceMonth0)',Value</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Thank you!</SPAN></P></BODY></HTML> Tue, 24 Jun 2014 13:37:30 GMT saggroad 2014-06-24T13:37:30Z AGGR with additional dimension https://community.qlik.com/t5/QlikView/AGGR-with-additional-dimension/m-p/735624#M475986 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>In the below aggregation which works well&nbsp; I also want to add only 'NEW' products (TYPE = "NEW').</P><P>Could someone tell me how would I include also TYPE = 'NEW' in the below aggregation so that it only sums up 'NEW'</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>=-</P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">only</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">INFPERIOD</SPAN><SPAN style="font-size: 8pt;">)='$(vInforceMonth0)',Value</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Thank you!</SPAN></P></BODY></HTML> Tue, 24 Jun 2014 13:37:30 GMT https://community.qlik.com/t5/QlikView/AGGR-with-additional-dimension/m-p/735624#M475986 saggroad 2014-06-24T13:37:30Z