Hi SCD Buist
You can't do such a function in QlikView - it's all table based.
I suggest that you load the first table in "unpivoted" from fields Column - > to Invalidates row. You can do this using the cross table function in the script:
LOAD Column, Missing, Wrong, RequiresCleaning, InvalidatesRow
You can then join the null column on separately.