4 Replies Latest reply: Jan 17, 2014 11:37 AM by Jasmine Lin RSS

    If statement questions

      Hi QlikView Peers,

       

      I need help with following statement. I was able to change "Legal" to "Global Functions - Other" but somehow the script isn't able to include  "Compliance & Control" to "Global Functions - Other". Please help.


           IF([Primary Sector Impacted_1]='CC-Staff' and [Primary Business Impacted]='Legal' OR 'Compliance & Control', 'Global Functions - Other')

       

      Thanks,


      Jasmine