topic Re: AGGR with selections in QlikView https://community.qlik.com/t5/QlikView/AGGR-with-selections/m-p/457409#M484272 <HTML><HEAD></HEAD><BODY><P>You didn't specify an aggregation function to use in the aggr, so the default only() function is used. That most likely causes the aggr function to return only nulls.</P><P> Possibly you don't need the aggr at all, but it's impossible to tell without looking at the qvw document.</P></BODY></HTML> Mon, 10 Jun 2013 15:28:35 GMT Gysbert_Wassenaar 2013-06-10T15:28:35Z AGGR with selections https://community.qlik.com/t5/QlikView/AGGR-with-selections/m-p/457408#M484271 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I have this expression:</P><P></P><TABLE><TBODY><TR><TD>=sum(&nbsp; $(vFiltroStockA)&nbsp; EstadoUnidad = {'Sin Asignar'},&nbsp; VariableNombre = {'Linea Barco'}, [Tipo Unidad] = {'Propias'} &gt;}&nbsp; aggr(if(num(LBMes) &lt;&gt; num(month(today()))&nbsp; and num(LBMes) &lt;&gt; num(month(today())-1) and ReservaDiaSTOCK = 1, costoUnidades.costoUnidadQV&nbsp; ),IDFabrica</TD><TD>))</TD></TR></TBODY></TABLE><P></P><P>$(vFiltroStockA) = filters for selection (do nothing when fields are selected) example: EMPRESA_0km = ,</P><P></P><P>The problems is when select something in EMPRESA_0km field, aggr return 0... i dont know how to use aggr with selections, help!</P><P></P><P>thanks!</P></BODY></HTML> Mon, 10 Jun 2013 15:22:03 GMT https://community.qlik.com/t5/QlikView/AGGR-with-selections/m-p/457408#M484271 2013-06-10T15:22:03Z Re: AGGR with selections https://community.qlik.com/t5/QlikView/AGGR-with-selections/m-p/457409#M484272 <HTML><HEAD></HEAD><BODY><P>You didn't specify an aggregation function to use in the aggr, so the default only() function is used. That most likely causes the aggr function to return only nulls.</P><P> Possibly you don't need the aggr at all, but it's impossible to tell without looking at the qvw document.</P></BODY></HTML> Mon, 10 Jun 2013 15:28:35 GMT https://community.qlik.com/t5/QlikView/AGGR-with-selections/m-p/457409#M484272 Gysbert_Wassenaar 2013-06-10T15:28:35Z