Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

AGGR with selections


I have this expression:

=sum(  $(vFiltroStockA)  EstadoUnidad = {'Sin Asignar'},  VariableNombre = {'Linea Barco'}, [Tipo Unidad] = {'Propias'} >}  aggr(if(num(LBMes) <> num(month(today()))  and num(LBMes) <> num(month(today())-1) and ReservaDiaSTOCK = 1, costoUnidades.costoUnidadQV  ),IDFabrica))

$(vFiltroStockA) = filters for selection (do nothing when fields are selected) example: EMPRESA_0km = ,

The problems is when select something in EMPRESA_0km field, aggr return 0... i dont know how to use aggr with selections, help!


1 Reply

Re: AGGR with selections

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.

Possibly you don't need the aggr at all, but it's impossible to tell without looking at the qvw document.

talk is cheap, supply exceeds demand
Community Browser