topic Re: How to count null records in each field sing System table in QlikView

How to count null records in each field sing System table

bhupesh_gupta — Fri, 17 Nov 2017 12:42:08 GMT

Dear Experts

In one of my new requirement, I want to create a straight table which will have $field as my dimension and want to know the count of null records in each field.

I was trying the below expression but it is not giving me all the fields with the NULL records count

$(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',count({1<[' & $Field & ']={""}>}[' & $Field & '])', ',') & concat(right($Field&')',1)))

Please note that my table has 30 different fields , and all are having few Null records in them, but above expression only show 10 fields with the correct result.

Kindly help me in narrow downing the root cause.

Regards

Bhupesh

Re: How to count null records in each field sing System table

Chanty4u — Fri, 17 Nov 2017 12:53:58 GMT

use

=Nullcount(yourfield)

Re: How to count null records in each field sing System table

bhupesh_gupta — Fri, 17 Nov 2017 12:59:27 GMT

Hi Chanty

As I said I have 30 + fields in my system table , so I can't mention each and every field name separately in every expression

Regards

Bhupesh