Adding filters in formula, without SUM function

[JvanStijn]

Hi everyone,

I am wanting to do a calculation, where one field needs to be subtracted without the sum function. With the SUM in it, the formula is working fine, but without the sum, I can not apply my filters into the formula.

I am talking about the InkoopPromo field.

Does anyone know how this works?

[rubenmarin]

Hi, this will only work if InkoopPromo has only one value, if it has more than one different value it will return Null() and using anull in a substraction or division will return Null().

IF InkoopPromo has more than one value you need to tell Qlik what to do with those different values: Sum(), Avg()... or yu can enclose all theexpression in an Aggr() to split the expression by a dimension that makes InkoopPromo to have only one value for each dimenison value.

Sum({<Set analysis>} Aggr([Expression], [DimensionFieldName]))