Filtering whitin a measure

[AidaAR]

Hello all,

I am currently developing an app where I need to duplicate a same measure with different conditions each time. My problem/error comes when trying to use a comparison filter different from equal for a numeric field:

SUM({<[AÑO RF]={$(vL.AñoActual)},[MES RF]={$(vL.MesActual)}, [LINEA RF]={3330,3350}>}[PESO RF])

That works fine but:

SUM({<[AÑO RF]={$(vL.AñoActual)},[MES RF]={$(vL.MesActual)}, [LINEA RF]={3330,3350}, ACX<={3544}>}[PESO RF])

gives the following error:

Error in set modifier expression

Can anyone help me? Please? 😖

[Or · Accepted solution]

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

Short version - you don't use <= in this context, you place that within the search (inside the curly brackets).

[Anil_Babu_Samineni · Accepted solution]

Maybe like this

Sum({<[AÑO RF]={$(vL.AñoActual)},[MES RF]={$(vL.MesActual)}, [LINEA RF]={3330,3350}, ACX={"<=3544"}>}[PESO RF])