10 Replies Latest reply: Jan 30, 2018 10:28 AM by Josefina Fasoli RSS

    Replace null value with text

    Josefina Fasoli

      Hello everyone

       

      I'm working in Qliksense with a table like this:

       

      NullValues.PNG

      For some plan types there is no value for client type. I need those records to be considered as Person.

      I've tried if (isNull("Client Type"), 'Person', "Client Type") but nothing has changed.

       

      Any thoughts?

       

      Thanks!