Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
carlcimino
Creator II
Creator II

IntervalMatch on Resident Table

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

 

12 Replies
Not applicable

I'm sorry i don't understand. Perhaps post it under a new thread and I will take a look for you.

carlcimino
Creator II
Creator II
Author

Your buckets.  0 and 100. If my fact table has negative, or null values or numbers higher than 100 what happens?  How would you account for those in your inline load?

Not applicable

The data in my inline load is the age groups you provided on your original question and assumes the DRIVER_AGE in your resident load has positive values (source database shouldn't allow negative values here!)

Bottom line - i'm no expert but if you prepare the inline load according to the data in your fact table, it should do the trick for you.