title: Why are formulas not propagating in null fields?
body: <p>I'm trying to change the value of nulls to something else that can be used to filter. This data comes from a QVD file. The field that contains nulls, contains nulls due to no action taken on those items ( they will eventually change to something else once an action has been taken).  I found <a href="https://community.qlik.com/t5/QlikView-Documents/NULL-handling-in-QlikView/ta-p/1484472?attachment-id=135541" rel="nofollow noreferrer">this link</a>  which was very informative but i tried multiple solutions from the document to no avail. </p>
  
  <p>What i don't quite understand is that whenever i make a new field (in the script or as an expression) the formula does not propagate in the records that are null, it shows " - ".  For instance, the expression isNull(ActionTaken) will return false in a field that that not null, but only " - " in fields that are null.  If i export the table to Excel, the " - " is exported, i copy this cell to a text analyzer i  the UTF-8 encoded is \x2D\x0A\x0A, i'm not sure if that's an artifact of the export process.</p>
  
  <p>I also tried using the <a href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/NullAsValue.htm" rel="nofollow noreferrer">NullAsValue</a> statement but no luck.  Using a combination of Len &amp; Trim = 0 will return the same result as above.  This is only one table, no other tables are involved.</p>
  
  <p>Thanks in advance.</p>