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

Convert expression with if and total to set analysis

Hi everybody

you know how to convert this expression ? i wanna delete the if and use set analysis, what i have a total, i dont know what to do

the expression is here

sum({1 <AÑO={$(=MAX (AÑO))},MES_AÑO_NUMERO={"<=$(=NUM(MAX (MES_AÑO_NUMERO)))"}>}

total if(AGRUPACION_CALIFICACION<>'1' and ES_RENUNCIA=2,$(M_EMPLEADOS_BAJA),0))

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Try with

sum({1 <AÑO={$(=MAX (AÑO))},MES_AÑO_NUMERO={"<=$(=NUM(MAX (MES_AÑO_NUMERO)))"}, AGRUPACION_CALIFICACION={*}-{'1'}, ES_RENUNCIA={2}>}

total $(M_EMPLEADOS_BAJA),0)

maxgro
MVP
MVP

maybe

sum({1<

AÑO={$(=MAX (AÑO))},

MES_AÑO_NUMERO={"<=$(=NUM(MAX (MES_AÑO_NUMERO)))"},

AGRUPACION_CALIFICACION-={1},

ES_RENUNCIA-={2}

>}

total $(M_EMPLEADOS_BAJA) )