Return count where field is blank

[#1]

I need to do a unique count of UserNames where the Firm field is blank

I tried this, but it didn't work

=COUNT(DISTINCT {$<Firm-={'*'}>}UserName)

any ideas?

[venkatg6759]

=Count({$<Firm={' '}>}Distinct UserName)

[#3]

NullCount([{set_expression}][ distinct ] [ total [<fld {, fld}>]] expression)

Returns the aggregated count of NULL values from expression or field iterated over the chart dimension(s).

You might try the nullcount function. The above was taken from QlikView help file.

[#4]

This didn't work. It returned 0

[#5]

How are your nulls formatted?

[#6]

It's a text field, which is totally blank

[#7]

Have you tried =count(distinct {$<Firm = {'',' ',null}>} UserName)

[#8]

I think my problem may be solved another way

The root issue is that this expression does not count UserNames where the Firm field is blank

=COUNT(DISTINCT {$<Firm-={'ACME','*TEST*'}>}UserName)

Is there a way to alter this to ensure it includes UserName where the Firm field is blank, whilst also excluding Firms called ACME or with TEST  in them?

[#9]

Maybe in your load script, use something like if(Firm = ' ', null, Firm) as Firm? so then all blank values are associated with nulls, then you can use nullcount?

[CELAMBARASAN]

Something like this

=COUNT(DISTINCT {$-<Firm={'*'}>}UserName)