Discussion Board for collaboration related to Creating Analytics for QlikView.
I short question. Where is exactly the differnce between for example
if( One > Two, Count(Nr), Null())
count(if( One > Two, Nr, NUll())) ?
the first one calculates One > Two onece and returns the count of Nr or Null
and the second one calculates One > Two for every row and returns the count of Nr where One > Two.
Short answer is here: Sum(if(...)) vs If(Sum(...), Sum(...))
The first one will give you a count of the field Nr where one is greater than two
The second will will return the field value of Nr where one is greater than two