8 Replies Latest reply: Jun 12, 2017 11:03 AM by Latief Pinder RSS

    Records with Null Values are going unaccounted for... What syntax can I use within the “Expression Editor” for them to be included?

    Latief Pinder

      20170607

      Qlik Sense Desktop 3.2 SR3

       

      Hello All...this is my first Programming App question ever!...Be Nice...

       

      Question: Records with Null Values are going unaccounted for.... What syntax can I use within the “Expression Editor” for them to be included?

       

      Prerequisite:

      I cannot change the data before or during Import. (No use of LOAD or SELECTED scripts possible.) The COMPLETION_DATE date field is loaded as a string (General text).

       

      The rest is presented within the screen shots attached.

      I tried "IsNull" clauses, "Replace" clauses, "If, Then, Else" clauses to no avail.

       

      Thanks in advance!DateCompleted001.PNGDateCompleted002.PNG