Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try it,
If (NameColumn=0,Count(NameColumn))
or Count({<NameColumn={0}>}NameColum)
Another way
sum(if(value=0,1,0))