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.




      this returns 20


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



      hope I explained that ok,