3 Replies Latest reply: Sep 21, 2015 11:10 AM by Henric Cronström RSS

    Multiple conditions under if statement in QlikView Script

    sneha jha

      I am trying to create a field/dimension based on multiple if statement.


      However, I get error if I try to use multiple conditions under one if statement.

      For example:-


      if([Country] = 'France ',[Valid_YN]= 'Yes',[Code]= 'AA5','AA6','AA3',[Branch]<>'221,'223','224',[Amount1],'0',

      if([Country] = ''France' and [Process]  = 'A','B' ,[Company] = 'X',[Amount1]+[Amount2])) as [Net_Amount]


      Could any one please help me to work on the right approach towards this issue ?


      Thanks !!!!