1 Reply Latest reply: Jun 18, 2013 12:34 PM by j i RSS

    NullCount is not getting the correct number of null values

      I'm working in finding the number of null values and using the NullCount formula. The results that I am getting are different from the number in the excel sheet that consists of the raw data.

       

      The number is excel is 180 while in Qlikview the total amounts to 111.

       

      Other formulas used (get same values as for nullcount) but derived the same results.

       

        count( IF( IsNull([Security Rating]), [Business Group]))

       

        count(if(len(trim([Security Rating]))=0,[Business Group]))

       

      Maybe there are other suggestions?

       

      Thank you!