11 Replies Latest reply: Apr 3, 2015 5:35 AM by appi karna RSS

    CASE Expressions

    appi karna

      HI

      Can somebody please help me to fix the below sql expression in qlikview?

       

      Select case when revenue_flag=1 and revenue_amount is not null then null else revenue_amount end as display from HR_LOG.EP_LB_LOG

       

      Thanks