topic Grouping Based on Value within Range in QlikView

Grouping Based on Value within Range

villegasi03 — Thu, 15 Nov 2012 00:01:42 GMT

I am trying to find the easiest way to group employees based on tenure. I have everyones start date and I was going to get the number of days that they have been employed by taking the current day minus the start date. I then want to join my list to the table below which would give me their tenure group.

Any assistance would be great. Thank you.

TenureGrp	MinDays	MaxDays
0 to 2 Months	0	59
2 to 4 Months	60	119
4 to 6 Months	120	179
6 to 8 Months	180	239
8 to 10 Months	240	299
10 to 12 Months	300	360
Over 12 Months	361	1000000

Re: Grouping Based on Value within Range

Gysbert_Wassenaar — Thu, 15 Nov 2012 10:06:12 GMT

You can use the intervalmatch function. See the attached example for a demonstration of this function.

Re: Grouping Based on Value within Range

lironbaram — Thu, 15 Nov 2012 10:51:59 GMT

you can use the class function ,

attach is an example

Re: Grouping Based on Value within Range

villegasi03 — Thu, 15 Nov 2012 14:52:03 GMT

Gysbert - thank you for the usefule info.

Liron - Thank you for the example as well. I have never used the class function before. This actually worked out perfect. It also gave me a million ideas on how to use it on other projects.

thanks to all for you assistance.

Re: Grouping Based on Value within Range

Gysbert_Wassenaar — Thu, 15 Nov 2012 15:08:12 GMT

Personally, I prefer the intervalmatch in cases as these. You have more flexibility with the names of the ranges and you aren't limited to the fixed interval width of the class function. For months >12 you need an extra if statement to group all classes over 12 months together.

Re: Grouping Based on Value within Range

villegasi03 — Thu, 15 Nov 2012 15:10:23 GMT

Gysbert - Crazy that you just replied. I just tried to integrate the class method and I ran into just that issue. Thank you for pointing that out.