Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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]))