Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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) )