topic Re: Sum(if(...)) vs If(Sum(...), Sum(...)) in QlikView

Sum(if(...)) vs If(Sum(...), Sum(...))

Anonymous — Fri, 21 Aug 2015 14:42:04 GMT

Hey everyone,

Is there an advantage or difference between using sum(if)) vs if(sum())?

Re: Sum(if(...)) vs If(Sum(...), Sum(...))

marcus_sommer — Fri, 21 Aug 2015 14:57:41 GMT

Yes there are differences. If I rembemer correctly has hic‌ this in one of his blog-postings explained. But better is you forget about it and used instead set analysis, like : sum{< Dimension = {'Some Values'}>} Value)

- Marcus

Re: Sum(if(...)) vs If(Sum(...), Sum(...))

swuehl — Fri, 21 Aug 2015 14:58:38 GMT

There is a big difference:

=sum(if( Condition, Then, Else))

Here the condition is evaluated on record level, the result of each evaluation is then aggregated.

=If( sum(), Then, Else)

Here the aggregation happens first, then the result of the aggregation is used in the condition to decide on Then or Else branch.