Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How can i get total no of non null records column wise?

Hi All,

I am trying to create a ETL testing dashboard . I am looking for ways to create to no of non null& null record count column wise for tables.

please advise me

1 Reply

Re: How can i get total no of non null records column wise?

Try this:

Dimension:

$Field

This can be used to calculate number of nulls:

$(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',nullcount([' & $Field & '])', ',') & concat(right($Field&')',1)))

Subtract the above from Number of records to find non null.

Community Browser