topic Apply Map Question - Using a range of values in QlikView

Apply Map Question - Using a range of values

Thu, 25 Mar 2010 11:45:29 GMT

Is it possible to use the APPLY MAP function for a range of values?

The scenario i have is that i have a filed containing a number, this number relates to a duration (in days)

e.g. 1.032424

What I want to do is to categorise this duration into a banding, for instance '1 to 3 days'

So i want to take my original table, and create a new field for each row which states the band that each duration falls into

Duration Band

1.02323 1 to 3 days

0.5656 Less than 1 day

5.5353 3 days to 1 week

.... and so on

So the sort of mapping i need to carry out is dependent on the number range the duration falls in

< 1 maps to 'Less than 1 day'

>= 1 AND < 3 maps to '1 to 3 days'

Can this be done, my research suggests that an apply map is the tidiest way to do it, but the only examples i can find are exact mappings, and don't cater for ranges such as this.

Is this possible?

Thanks in advance

Apply Map Question - Using a range of values

Thu, 25 Mar 2010 12:04:04 GMT

Hi,

please see if this example is helpful to slove your requirement.

Good luck!

Rainer

Apply Map Question - Using a range of values

Thu, 25 Mar 2010 12:22:23 GMT

Thanks Rainer, I'm still using the personal edition, so i guess i won't be able to open this without messing up my licence.. any chance you could copy and paste the bits of the script that do this in your example?

Cheers!

Matt

Apply Map Question - Using a range of values

Thu, 25 Mar 2010 12:30:38 GMT

O.K!

Now you can open this version by personal edition without any problems.

We tested it some times and it was succesful.

Rainer

Apply Map Question - Using a range of values

Thu, 25 Mar 2010 12:38:20 GMT

Perfect, thank you