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
![Singaravelu_R_0-1616478925938.png Singaravelu_R_0-1616478925938.png](https://community.qlik.com/t5/image/serverpage/image-id/51647iD6210B79A757BBE8/image-size/medium?v=v2&px=400)