Filter not working into Field into aggr distinct sum

Anonymous — Thu, 23 Nov 2017 17:59:22 GMT

I wish use de next variable content :

if(Date#(C_Mes,'YYYYMM')='201709', 201708

, if(Date#(C_Mes,'YYYYMM')='201710', 201719

, if(Date#(C_Mes,'YYYYMM')='201711', 201710)

)

Into of expresión:

aggr( NODISTINCT sum( {1<N_Mes=,N_Anio=,N_Mes2=,C_Mes=,C_Mes={$(vSecosMex_MesNumerico)} >} Habil ) , N_Articulo )

But not working. Only It works well when put number into expresión, for example:

aggr( NODISTINCT sum( {1<N_Mes=,N_Anio=,N_Mes2=,C_Mes=,C_Mes={201708} >} Habil ) , N_Articulo )
aggr( NODISTINCT sum( {1<N_Mes=,N_Anio=,N_Mes2=,C_Mes=,C_Mes={201709} >} Habil ) , N_Articulo )
aggr( NODISTINCT sum( {1<N_Mes=,N_Anio=,N_Mes2=,C_Mes=,C_Mes={201710} >} Habil ) , N_Articulo )

In the image can watch the configure and result

I hope it helps!

Stalin

topic Filter not working into Field into aggr distinct sum in QlikView