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.