This content has been marked as final. Show 3 replies
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.
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,