Showing Number of Nulls for Each Field

[#1]

I would like to create a table that lists every field, which has columns for the total number of nulls, the percentage of rows that have a null, etc. What is the best way to go about this? I have a pivot table that uses $Field as the dimension, but I am unsure how to count the null values in Qlikview.

[hectorgarcia]

thanks Settu for your contribution with the field observer.

Is it possible to generate the same table but in the script?  to create data qulaity qvd's with this content?

[mehul_qlik]

Hi settu_periasamy,

I am getting 0 as null value count while using above expressions . Can you please help me

[mehul_qlik]

Hi Sunny,

I am getting 0 after using you expression. Can you please help me on this . 

[gq]

To count the Nulls, either you can use Isnull function or length function.

I usually use Len(Trim(Field)) = 0 to check if the value of the field is null,  Trim is used to make sure it does not count any spaces or blanks.

To count the nulls in the field,  can use if condition in combination with Len Function.

Try below
Sum(distinct IF(Len(Trim(Field)) = 0, 1, 0))

[mehul_qlik]

Thanks ! I tried but still it giving me 0 as results.