topic Null count issue in QlikView

Null count issue

Tue, 21 Jan 2014 17:04:35 GMT

In order to make the Null values appear in list boxes and be selectable, we use the following code:

NullAsValue *;

Set NullDisplay = '<NULL>';

However, now, if we want to count the number of null elements, the nullcount function no longer works in a statistics box (it returns zero even though there are null elements). Is there anyway to fix this? Would it involve making a custom function (and how would one construct such a custom function)?

Any help would be appreciated

Re: Null count issue

Anonymous — Tue, 21 Jan 2014 17:13:55 GMT

Stephen

This expression with set analysis should work. [Replace [YourField] with your field name]

=count( { <[YourField]={'<NULL>'} > } [YourField] )

Best Regards, Bill

Re: Null count issue

iktrayanov — Tue, 21 Jan 2014 17:22:27 GMT

One solution could be if you load your field of interest for example - Field1 twice in the script something like this

Table1:

Load

...

Field1,

Field1 as Field1_

NullAsValue *;

NullAsNull Field1_;

Set NullDisplay = '<NULL>';

Table2:

Load

...

Field1,

Field1_

resident Table1

Re: Null count issue

Tue, 21 Jan 2014 18:56:22 GMT

Hi Bill! This works for the pivot table, but there's I can't figure out how to include an expression in the statistics box

Re: Null count issue

Anonymous — Tue, 21 Jan 2014 19:02:33 GMT

Stephen

A bit of a bodge, but you could put that expression in a text box and the place it over the statistics box so it appears over the figure you don't want.

Or maybe you could try the suggestion iktrayanov posted.

Best Regards, Bill