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

    CASE Expressions

    appi karna


      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