Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Not working content variable into aggr sum

Hi

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:

ejemplo_secos_foro_v1.png

I wish find value of other time and put certain date

Hope that helps,

Stalin

0 Replies