5 Replies Latest reply: Feb 13, 2017 3:22 AM by vivek pv RSS

    ISNOT NULL()-Scripting

    vivek pv

      Hi Experts,

      I want to handle IS NOT NULL in scripting.

      In OBIEE, they are using a case statement like,CASE WHEN NOT AMOUNT IS NULL THEN AMOUNT ELSE 0

      we can write case statement as IF() statement. but I don't know how to write NOT IS NULL.

      I think in QlikView we only ISNULL(), but there is no NOT IS NULL().

      Can you help me in writing this.

       

       

       

      Thanks,

      Vivek