Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Different counters

Hi,

I short question. Where is exactly the differnce between for example

if( One > Two, Count(Nr), Null())

and

count(if( One > Two, Nr, NUll())) ?

Thanks...

3 Replies
sebastianlettner
Partner - Creator
Partner - Creator

Hi,

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.

Regards

Sebastian Lettner

tresesco
MVP
MVP

Mark_Little
Luminary
Luminary

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