Blanks in Data

[#1]

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

[sunny_talwar · Accepted solution]

Try this:

=Count(DISTINCT {<motor = {"=Len(Trim(motor)) > 0"}>} cars)

[#3]

that worked, thank yous

[sunny_talwar]

Not a problem. I am glad I was able to help.

Best,

Sunny