Adding filters in formula, without SUM function

JvanStijn — Wed, 22 Dec 2021 16:28:40 GMT

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?

Re: Adding filters in formula, without SUM function

rubenmarin — Sun, 07 Nov 2021 08:28:59 GMT

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]))

topic Adding filters in formula, without SUM function in App Development

Adding filters in formula, without SUM function

Re: Adding filters in formula, without SUM function