12 Replies Latest reply: Apr 20, 2017 11:40 AM by Nishant Goel RSS

    IntervalMatch on Resident Table

    Carl Cimino

      Hello, I am trying to bucket uneven age groups on a resident table.  I'd like the buckets to be as follows.  I'd like the age group be appended to the resident table.  How would I accomplish that?

       

      0 to 14

      15-19

      20-24

      25-29

      30-34

      35-39

      40-44

      45-49

      50-54

      55+

       

        Here's my resident table.

      Quotes:
      Load
      DRIVER_AGE,
      POLICY_NUMBER
      From C:\QlikView\Daily Quote\v14\CombinedQuotes.qvd (qvd);


      Thanks in advance!

      Carl