7 Replies Latest reply: Sep 12, 2013 7:10 AM by Ridhaa Hendricks RSS

    replace a null with comment

    Ridhaa Hendricks

      load   *,         

             if(isnull(AGENTNAME),'***NO angent***',AGENTNAME) as "oAGENTNAME";

             //resident ICDPUB.T_UCP_STAFFWORKNO;

       

      Hi

       

      How do i replace a null value with a "comment".

      i have tried the above :

       

      this Qlikview does not see.