Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Blanks in Data

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

1 Solution

Accepted Solutions

Re: Blanks in Data

Try this:

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

3 Replies

Re: Blanks in Data

Try this:

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

Not applicable

Re: Blanks in Data

that worked, thank yous

Re: Blanks in Data

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

Best,

Sunny

Community Browser