Discussion Board for collaboration related to QlikView App Development.
To load without nulls I usually put:
Also works, for nulls and empty strings:
To also exclude empty spaces:
A remark: when you load from qvd or Excel, you have real null values; when you load from csv or txt, you get empty strings instead, but 2nd and 3rd formula work.
Hope this helps.