3 Replies Latest reply: Nov 11, 2015 4:12 PM by Sunny Talwar RSS

    Blanks in Data

    Freddie Cornejo

      Hello, as I start to learn qlikview, I ran into a small problems I cant figure out.

       

      In my data a have a lot of blank spaces I want to count.

       

      =num (count (DISTINCT [cars]))     lets say this equals 100

       

      when I try to filter a field that has blanks like this.

       

      =count (DISTINCT{$<motor-={""}>}[cars])

      i'm not sure why I get 100 as the answer, when I clearly see blanks in the data. I know there are blanks because I use.

       

      =nullcount(motor

       

      this returns 20

       

      I want to know how many cars did not have a motor.

       

       

      hope I explained that ok,

       

      thanks