SUM IF executing multiple times in expression

SamQlik — Sat, 16 Nov 2024 00:32:29 GMT

I'm puzzled by the logic being executed in an expression when two snippets of code are used.

Firstly, if I run this piece of code, it returns 1, as expected:

=SUM( IF(false(), 1, 1) )

However, if I modify the formula slightly and replace the success variable to be summed with an actual field, the formula returns 24 which happens to be the count of the field as well:

=SUM( IF(false(), myField, 1) )

Does anyone understand why this is happening and how can I get around it?

Thanks

Re: SUM IF executing multiple times in expression

Or — Thu, 04 Jun 2020 14:06:15 GMT

Presumably, the first expression is evaluating once because it's just an empty function, while the second expression is evaluating once per myField value, so 24 times.

It sounds like what you're after is actually:

If(False(),Sum(Myfield),1)

topic SUM IF executing multiple times in expression in QlikView

SUM IF executing multiple times in expression

Re: SUM IF executing multiple times in expression