Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
maverjannet
Valued Contributor

Re: Count Zeros in a column

Try it,

If (NameColumn=0,Count(NameColumn))

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

Re: Count Zeros in a column

Another way

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

Community Browser