Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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))