Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=Count(DISTINCT {<motor = {"=Len(Trim(motor)) > 0"}>} cars)
that worked, thank yous
Not a problem. I am glad I was able to help.
Best,
Sunny