topic Re: Filtering whitin a measure in App Development

Filtering whitin a measure

AidaAR — Mon, 18 Dec 2023 13:32:42 GMT

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? 😖

Re: Filtering whitin a measure

Or — Mon, 18 Dec 2023 13:34:25 GMT

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-modifiers-advanced-searches.htm

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

Re: Filtering whitin a measure

Anil_Babu_Samineni — Mon, 18 Dec 2023 19:11:11 GMT

Maybe like this

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