Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Zeros in a column

Hello, I am attempting to do a count on a straight table of Zeros in a particular column. I am trying to do this calculation in a separate text object as a measurement.

I am not very familiar with Qlik syntax and am having difficulty formulating the expression.

IF(Count(Value)=0,1,0)

How would I be able to do this?

2 Replies
Anonymous
Not applicable
Author

Try it,

If (NameColumn=0,Count(NameColumn))

or  Count({<NameColumn={0}>}NameColum)

robert_mika
Master III
Master III

Another way

sum(if(value=0,1,0))