Cross table not showing null

[Singaravelu_R]

Hi Team, I have attached sample file which I want to show the table of Each column with how many null values.

I have used cross table and reload the data as per below script,

NullTest:

CrossTable(Fields, Data)

LOAD RowNo() as NUM,

ID,

[Start Date],

[End Date],

[Number of Cycles],

Protocol,

[Drug Name],

Dose,

Route,

Frequency,

[Frequency Unit],

Day,

[Cycle Number],

[Cycle Start Date],

[Cycle End Date]

FROM [lib://AttachedFiles/Sample Data.xlsx]
(ooxml, embedded labels, table is Sample);

But I could not able to count null values of column. It not coming null values,

My result in the qlik below, result not showing null values. Please help