8 Replies Latest reply: Oct 15, 2014 12:13 PM by test test RSS

    Script if/And statements

      Hi guys

       

      I really hope someone can help me.

       

      I have version 8 of Qlikview and have a document built thats is fed by numerous different excel workbooks.

       

      One of these worksheets is not in the same format as the others so I wish to put an if(and statement ( or the equivilent) within the script so I may build charts etc quickly enough.

       

      This is my condition

       

      if( and([Type of Event] ='Static amendment' ,[Issue held with] = 'Cops Team'), as [If static error is corp ops responsible] = 'Yes')

       

      But Qlikview doent seem to like AND function ,

       

      Can anyone help with the above ?

       

      Thanks

      A