6 Replies Latest reply: Feb 1, 2015 11:04 AM by Alex Piccolo RSS

    Measuring net valid contracts started vs ended- Help

    Alex Piccolo

      I am having problems trying to create chart of net contracts started vs ended.  I have tried using insurance contract example for the link below and using the interval match and cant figure it out.  The loop creates millions of records.  I am trying to right the script so when I make one chart of total contracts shipped less expired year.

       

      ChartDifference.PNG

      Attached is the qvw with example data.

       

      Generating Missing Data In QlikView