3 Replies Latest reply: Sep 17, 2012 5:59 PM by Mayil Vahanan Ramasamy RSS

    If statements in load script

      I'm new to Qlikview - at least developing scripts and I need to put in three If statements in my load script. 

       

      The next three lines are each line I need to calculate in the script:

       

      Effective Date + 365 days as Renewal,

      Effective Date <= 365 days AND Agent First Application Date <= 365 days as First Year New Agent,

      Effective Date <= 365 days AND Agent First Application Date >= 365 days as First Year Existing Agent

       

      I read the initial code as an If statement within the load as IF(Effective Date + 365 Days, __) as Renewal - is there any values I'd put in the THEN part or do I leave that alone?

       

      Thanks in advance.