2 Replies Latest reply: Mar 10, 2015 2:21 PM by Robert Mika RSS

    Count Zeros in a column

    Donish Nasim

      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?