If you load the XLSX file using the "Table Files" button in the script editor, this will load only non-empty cells from Excel, because you only have one column. It has nothing to do with QlikView but with the Microsoft Excel driver. If you had two colums, the nulls will indeed be counted. What you can do instead is to create an ODBC driver entry to read files using it instead of the button.
Follow these steps:
Go to Startup, Run, C:\Windows\SysWOW64\odbcad32.exe
Add a new Excel (xlsx) driver and point it to your file, name it Excel1
Check the box "Force 32 bits" in the script editor.
Then use the following script:
ODBC CONNECT32 TO [Excel1;DBQ=C:\Files\count null.xlsx];
TableWithNulls:
LOAD invdate,
If(Len(invdate) = 0, RangeSum(1, Peek('NullCounter')), RangeSum(0, Peek('NullCounter'))) AS NullCounter;
SQL SELECT *
FROM `C:\Files\count null.xlsx`.`Sheet1$`;
This will return each of the lines with a counter that will be increased each time invdate has a null/empty value. The total number of nulls will be the Max(NullCounter).
.png "Miguel_Angel_Baeyens"){kind=avatar}
