Not working content variable into aggr sum

Anonymous — Thu, 23 Nov 2017 18:19:07 GMT

I wish call variable into expresión aggr sum

Variable:

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

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

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

)

Expresión:

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

This expression only work when use number value, for example:

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 )

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

The next image was visualized the code:

I wish find value of other time and put certain date

Hope that helps,

Stalin

topic Not working content variable into aggr sum in QlikView