Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Null count issue

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

1 Solution

Accepted Solutions
bill_markham

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

View solution in original post

4 Replies
bill_markham

Stephen

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

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

Best Regards,     Bill

iktrayanov
Creator III
Creator III

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

Not applicable
Author

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

bill_markham

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

View solution in original post