Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filter not working into Field into aggr distinct sum

Hi

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

ejemplo_secos_foro_v1.png

I hope it helps!

Stalin

0 Replies