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 ?