2 Replies Latest reply: Jun 1, 2011 10:51 AM by dconway10 RSS

    SQL iif Logic in Qlikview

      I want to perform the task that if done in SQL would be

       

      Sum(IIF([Field1] = 0,[Field2],0)). 

       

      I am having a hard time figuring out how to do it in Qlikview. I have tried

       

       

      Sum({$<[Field1] = {0} >} [Field2]) .  This returned 0.

      Any help would be appreciated.